Radgrid Filter search Date by month name or number in filter text

[Vishal]

Hello all,

I have a request to allow the user to search the Grid Date Column  by just entering the Month Name or Number from the Date part, and search the results.

I had tried some code for Custom filters..but I did not get the desired result.

Please find the screen shot for the above scenario.

Any suggestions are welcome.

Thank You

[Radoslav]

Hi Vishal,

To achieve the desired functionality you can try using the filter template where you can put textbox control and manually construct needed filter expression. On the following link you can find online example of RadGrid with different filter templates:
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/filtertemplate/defaultcs.aspx
Please give it try and let me know if you experience any problems.

Looking forward for your reply.

Regards,
Radoslav
Telerik

[Vishal]

Hi radoslav,
Thanks for your reply.

I tried to work out with some of the examples given in that link but could not work out any solution for this issue yet.. :(
A bit more clarification on the implementation side will be great  .


Thanks ,
Vishal

[Radoslav]

Hi Vishal,

I am sending you a simple example which demonstrates the desired functionality. The example uses string representation of the date time object in order to filter appropriately.
The other approach will be to add additional hidden column into the RadGrid which contains the corresponding date objects month’s numbers and to filter by it. In this case you do not need to use string representation of the date time objects into the original column.

I hope this helps.

Regards,
Radoslav
Telerik