At this moment Excel style filters are not available on all columns. Using the normal filter is an option, but takes much more time for the user to set. Please make this available ASAP (MoSCoW - should)
Also for other type of fields (not checkbox, date)
Priority order: checkbox, combo box, date, other
Page 1 / 1
This is definitely on our list to add to the product. Aldough, it is not planned for the Q1 release.
On what type of columns do you miss this kind of filtering the most?
New→On the backlog
Pity, our customer is holding back on Universal because this excel style filtering isn't working. I was assuming that it already worked because during technical presentations I was told that everything the WindowsGUI can do is now available in Universal but apperently that was a bit optimistic :(
Is it an option to add a inline filter-form above the grid for filtering the most important columns?
Pity, our customer is holding back on Universal because this excel style filtering isn't working. I was assuming that it already worked because during technical presentations I was told that everything the WindowsGUI can do is now available in Universal but apperently that was a bit optimistic :(
@Alban_T Could you clarify for which particular Control types you need the Excel-style filtering most urgently?
Pity, our customer is holding back on Universal because this excel style filtering isn't working. I was assuming that it already worked because during technical presentations I was told that everything the WindowsGUI can do is now available in Universal but apperently that was a bit optimistic :(
@Alban_T Could you clarify for which particular Control types you need the Excel-style filtering most urgently?
The most significant one that I couldn't solve is filtering like an IN-clause. For example a table with logging and I want to show the records for e.g. 2 users. With a properly setup filter I can filter on user = “piet” or user = “jan” but not for user IN("jan”,”piet”) Something like this:
Sounds like a great idea! We are encountering a similar problem right now.
Most columns where we would like to see this kind of filtering have a reference to another table and this is supported already, but we would love to see it for plain NVARCHAR() columns as well (and maybe other data types as well).
I’m also wondering whether it is possible to add this kind of filtering to the filter form and the advanced filters which can be saved as user preferences?
On the backlog→Planned
Upcoming Universal sprint we intend to include Excel-style filtering for Alphanumeric column types and Checkboxes. Note that we’ll implement a ‘Contains filter’ for the Alphanumeric column types.
@Alban_T The IN filter is currently not supported in the Filter form either. Please make sure to vote on below Idea and keep track of the status of that Idea:
Planned→Working on it!
Hi everyone,
In the 2025.3.10.0 release we added support of grid header filtering on alphanumeric-type columns.
Unlike the previous comment of Arie, the filtering is done using IN filtering - selecting multiple values instead of typing a text that matches the items you are looking for. The contains-filtering is still in the concept, because when the amount of items goes over a certain threshold we show the auto-complete editor or select values from. Searching for exact values uses a contains filter.
The filter popup now also contains the IN operator for alphanumeric-type columns, to represent the filter from the grid header and vice versa.
Next up will be support for numeric type of columns, which will work similar.
We hope this satisfies your needs so far. We are happy to hear your findings on this newly added functionality.