View Full Version : More Advanced Grid Filtering

Oct 16, 2014, 3:33 PM
We get heavy use out of the grid filters, and we would like to see more advanced grid filtering options, including:

1. For number filters, ability to use multiple filters together with an OR, such as (X < 5 OR X > 10) (but to still be able to choose to use the default AND behavior)
2. For all filter types, ability to do not equals-- for example X != 10 or Name != "John"
3. For string filters, ability to add multiple filter conditions to a single column-- for example (Name LIKE "John" OR Name LIKE "Jack")

We do most of our filtering remotely, so it is possible to implement these complex filters on the server side, but the challenge is creating the UI for accepting more advanced filters.

Oct 16, 2014, 3:54 PM

You can use FilterHeader and implement any desired behaviour

Oct 16, 2014, 4:11 PM
Yes, I have considered that. But in that case we would have to define some sort of boolean search specification that our users would use to type in the filters.

I think it would be much more intuitive to be able to use the normal gridfilters. Users expect something similar to Excel's column filter interface. If we could edit the menu of a column, this might make it easier to implement the UI we are imagining -- so that might be a related or substitute feature request (see http://forums.ext.net/showthread.php?43201-Customize-Grid-column-header-menu )