RadGrid Advanced Filtering (OR Clause)

[Dan]

I was wondering if there was a way to do advanced filtering in the Radgrid.  Something like for a single column I want to find value1 OR value2.  State = 'Colorado' OR State = 'New Mexico'.  In addition, is doing an OR between two columns possible using the filter bar/menu? State LIKE 'Colora%' OR ZipCode LIKE '80%'.
                                                 Thanks, Dan

[Konstantin Petkov]

Hi Dan,

You can add custom filtering for the respective column as explained in the docs below:

http://www.telerik.com/help/radcontrols/prometheus/?grdCustomOptionForFiltering.html

All the best,
Konstantin Petkov
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Dan]

That would work but I was hoping there was a way to allow the filter UI built into the grid to do it so the user can make on the fly advanced filters.  We were thinking about just overriding the grid's filtering, putting in an Aan/Or checkbox and taking whatever they put into the textboxes and just building out own query.  The requirement that makes it harder is that we have to remember the filter and use it each time that user visits the page so we'd have to manually repopulate the textboxes each time rather than just using the column's CurrentFilterFunction and CurrentFilterValue. 
Are there any plans in the future to incorperate a higher level of filtering into the grid's UI?

[Yavor]

Hi Dan,

You can manipulate the filter expression of the control directly. The filter expressions are SQL like, and you can use AND/OR keywords to concatenate more than one requirement. Additional information on this possibility is included in the following article.
I hope this information helps.

Regards,
Yavor
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center