Excel style filtering in Universal GUI

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?

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?

​@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?

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: 

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.

Update: the upcoming 2025.3.12.0 version will add support for grid header filtering on all kind of numeric columns. This release will be available on Monday the 17th of November as a Release Candidate and a week later as the official release.

Filtering date/time columns will be next.

We also have plans to change numeric filters to make a distinction between the qualitative or quantitative nature of a value. We can make the assumption that number columns that use a NUMERIC or CALCULATOR control are quantitative, other controls are quantitative. On quantitative columns we will offer a Between/range filtering experience. For example on a column with payments amounts. Both sum up all unique values in the current implementation.

Will be continued...