Skip to main content
Working on it!

Excel style filtering in Universal GUI

Related products:Universal GUI
Mark Jongeling
John Lunenburg
Geurt
eurban
+16
  • Mark Jongeling
    Mark Jongeling
  • John Lunenburg
    John Lunenburg
  • Geurt
    Geurt
  • eurban
    eurban
  • kenterweeme
  • PatrickW
  • Suleyman
  • Alban_T
  • tiago
    tiago
  • Marius Korff
    Marius Korff
  • Mark_Plaggenborg
  • avandervelden
  • Tolboom Jeffrey
  • NickJanssen
    NickJanssen
  • martijngaasbeek
  • JochemDeRoeck
  • lnieskens
  • gideon
  • Pierre
  • Bjinse
  • Dave Meijer

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

Did this topic help you find an answer to your question?

10 replies

Erik Brink
Moderator
Forum|alt.badge.img+5
  • Moderator
  • 497 replies
  • November 20, 2024

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?


Erik Brink
Moderator
Forum|alt.badge.img+5
  • Moderator
  • 497 replies
  • November 20, 2024
NewOn the backlog

Forum|alt.badge.img+6
  • Hero
  • 86 replies
  • January 13, 2025

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 :(


Erik Brink
Moderator
Forum|alt.badge.img+5
  • Moderator
  • 497 replies
  • January 13, 2025

Is it an option to add a inline filter-form above the grid for filtering the most important columns?


Arie V
Community Manager
Forum|alt.badge.img+12
  • Community Manager
  • 1030 replies
  • January 13, 2025
Alban_T wrote:

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?


Forum|alt.badge.img+6
  • Hero
  • 86 replies
  • January 13, 2025
Arie V wrote:
Alban_T wrote:

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:
 


 


NickJanssen
Captain
Forum|alt.badge.img+5
  • Captain
  • 43 replies
  • March 11, 2025

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?


Arie V
Community Manager
Forum|alt.badge.img+12
  • Community Manager
  • 1030 replies
  • June 2, 2025
On the backlogPlanned

Arie V
Community Manager
Forum|alt.badge.img+12
  • Community Manager
  • 1030 replies
  • June 2, 2025

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: 

 


Arie V
Community Manager
Forum|alt.badge.img+12
  • Community Manager
  • 1030 replies
  • June 11, 2025
PlannedWorking on it!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings