I have a RadGrid with multiple CustomFilteringColumns with drop downs in each. Everything works great except trying to filter by multiple columns. If I go from left to right as far as selecting my filters then it only filters by whatever filter that I selected first. If I go from right to left selecting my filters it works.
Example:
Column 1 Column 2 Column 3
Filter by column 1 then by column 2 then by column 3 it still only displays data based on the column 1 filter.
Filter by column 3 then by column 2 then by column 1 OR Filter by column 2 then by column 1 it works GREAT!
I know this really doesn't make any sense but I swear that it is doing this. Maybe it makes sense to some of you! Thanks for the help in advance!
Example:
Column 1 Column 2 Column 3
Filter by column 1 then by column 2 then by column 3 it still only displays data based on the column 1 filter.
Filter by column 3 then by column 2 then by column 1 OR Filter by column 2 then by column 1 it works GREAT!
I know this really doesn't make any sense but I swear that it is doing this. Maybe it makes sense to some of you! Thanks for the help in advance!
3 Answers, 1 is accepted
0
Hello baharris,
You can concatenate more than one option in the filter, by using AND/OR clauses, as shown in the filter Expression below:
([CustomerID] LIKE '%AAA%') AND ([ContactName] LIKE '%b%') AND ([CompanyName] LIKE '%a%')
I hope this helps.
Regards,
Yavor
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
You can concatenate more than one option in the filter, by using AND/OR clauses, as shown in the filter Expression below:
([CustomerID] LIKE '%AAA%') AND ([ContactName] LIKE '%b%') AND ([CompanyName] LIKE '%a%')
I hope this helps.
Regards,
Yavor
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
0
baharris
Top achievements
Rank 1
Rank 1
answered on 23 Jun 2008, 03:01 PM
That does not help me. I have 3 columns with 3 filtering drop downs. I don't neeed multiple options for one filter. I need to be able to select from left to right my values in the drop downs and for the grid to be sorted by these values. Like I said, it works if I go from right to left but not left to right.
0
Hello baharris,
Based on the information gathered thus far, as well as on the fact that you are using CustomFilteringColumns, I suspect that the problem may be with the implementation of the filtering items. In order to further address the issue, you can open a formal support ticket, and send us a small project, demonstrating the issue.
We will review it locally, and get back to you with our findings.
Greetings,
Yavor
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
Based on the information gathered thus far, as well as on the fact that you are using CustomFilteringColumns, I suspect that the problem may be with the implementation of the filtering items. In order to further address the issue, you can open a formal support ticket, and send us a small project, demonstrating the issue.
We will review it locally, and get back to you with our findings.
Greetings,
Yavor
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center