Phani Musale
Top achievements
Rank 1
Rank 1
Phani Musale
asked on 08 Feb 2010, 02:16 PM
Hi,
In the Radgrid, if I try to filter by a date column between two times it doesn't work. Basically I want to see all the records between "01/10/2010 12:00:00" to "11/10/2010 12:00:00". I would like to see this by entering the text - "01/10/2010 12:00:00 11/10/2010 12:00:00" in the Filter Textbox and selecting "Between" Filter Menu option on a DateTime column.
But I don't get the desired result. Infact as soon as radGrid encounters more than one space between a string it empties that string and makes CurrentFilterValue for that columns as a empty string. Can I make RadGrid not do so?
Filtering options that works on Radgrid are as follows:
- "01/10/2010 12:00:00" -> EqualTo, Greater Thans, etc.
- "01/10/2010" -> EqualTo, Greater Thans, etc.
- "01/10/2010 11/10/2010" -> Between.
Filtering options that DO NOT work on Radgrid are as follows:
- "01/10/2010 12:00:00 11/10/2010 16:30:00" -> Between. - I WANT THIS TO WORK
I am override the RaisePostBackEvent, but the filter value in the above case is emptied out.
Any help?
Thanks
In the Radgrid, if I try to filter by a date column between two times it doesn't work. Basically I want to see all the records between "01/10/2010 12:00:00" to "11/10/2010 12:00:00". I would like to see this by entering the text - "01/10/2010 12:00:00 11/10/2010 12:00:00" in the Filter Textbox and selecting "Between" Filter Menu option on a DateTime column.
But I don't get the desired result. Infact as soon as radGrid encounters more than one space between a string it empties that string and makes CurrentFilterValue for that columns as a empty string. Can I make RadGrid not do so?
Filtering options that works on Radgrid are as follows:
- "01/10/2010 12:00:00" -> EqualTo, Greater Thans, etc.
- "01/10/2010" -> EqualTo, Greater Thans, etc.
- "01/10/2010 11/10/2010" -> Between.
Filtering options that DO NOT work on Radgrid are as follows:
- "01/10/2010 12:00:00 11/10/2010 16:30:00" -> Between. - I WANT THIS TO WORK
I am override the RaisePostBackEvent, but the filter value in the above case is emptied out.
Any help?
Thanks
1 Answer, 1 is accepted
0
Hello Phani,
The default filter functions for the GridDateTimeColumn do not include Between/NotBetween as this would require one more RadDatePicker control in the column filter.
In order to implement the Between filter for date columns, you could try the approach illustrated in this demo.
Greetings,
Pavlina
the Telerik team
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.
The default filter functions for the GridDateTimeColumn do not include Between/NotBetween as this would require one more RadDatePicker control in the column filter.
In order to implement the Between filter for date columns, you could try the approach illustrated in this demo.
Greetings,
Pavlina
the Telerik team
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.