One column multiple fillters with OR logic

May 26, 2014 at 9:00 AM
Edited May 26, 2014 at 9:02 AM

I managed to make some simple filter widget that passes multiple filter values. It works but the filtering logic is "AND".


I filter with "Contains" and values "b" "d"
the result is

I wanted to get
Bird, Bark, Food

This example is simple but it shows the function. In the perfect world I would like to have an ability to use "Equals" filter with "Bird" "Bark" and get exactly those rows containing it.

Is there a way I can add my custom filtering logic? Or I can only add a widget but need to use the logic provided? Because in current situation the multiple filter logic uses "AND" to join filters while I would need "OR" join.
May 31, 2014 at 3:22 PM

Unfortunatly you can't do this now, because grid builds the expressions like:

items.Where(x=> <first expression>).Where(x=> <second expression>).Where .. etc

We need to change expression built behavour:

items.Where(x=> <first expression> && <second expression> && etc);
items.Where(x=> <first expression> || <second expression> || etc);

to accomplish this.

I copy your suggestion to work item and try to done it to next release
May 31, 2014 at 3:23 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.