This is a migrated thread and some comments may be shown as answers.

RadGrid Advanced Filtering (OR Clause)

3 Answers 236 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Dan
Top achievements
Rank 1
Dan asked on 24 Apr 2008, 04:21 PM
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

3 Answers, 1 is accepted

Sort by
0
Konstantin Petkov
Telerik team
answered on 25 Apr 2008, 12:25 PM
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
0
Dan
Top achievements
Rank 1
answered on 25 Apr 2008, 02:02 PM
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?
0
Yavor
Telerik team
answered on 30 Apr 2008, 12:23 PM
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
Tags
Grid
Asked by
Dan
Top achievements
Rank 1
Answers by
Konstantin Petkov
Telerik team
Dan
Top achievements
Rank 1
Yavor
Telerik team
Share this question
or