Using UP, it is already possible to create and save your own prefilters, by entering values for the available columns in the table. This always leads to an and-based prefilter, which has limited options.
I would like to be able to make my prefilters by writing a query or by saving my filter expressions. This way you can also make your own or-based prefilters, use subqueries or joins, etc.
Completed
Save your own prefilter queries / filter expressions
Being able to write your own query for a user defined prefilter is not an option due to security concerns. It is simply not feasible to allow this without imposing severe security risks.
However, the other option, saving filter expressions as prefilters, is possible and should allow for similarly powerful prefilters.
However, the other option, saving filter expressions as prefilters, is possible and should allow for similarly powerful prefilters.
- Rookie
- 3 replies
Really much appriciated if the saving of a filter expression would be possible.
+1- Apprentice
- 8 replies
It would be even better to be able to “share” the saved filter expression with other users or group.
+21- Superhero
- 510 replies
I like the idea and also the suggestion to share a filter with others.
A nice addition to this would be the possiblity to save sort order and column settings.
See my last post:
https://community.thinkwisesoftware.com/ideas/250
- Superhero
- 196 replies
I see it's on the backlog, but it's not really clear to me what exactly, and what's the target interface (Windows / web or Universal?) And does it include the OR statement? That would be a really welcome feature in the web environment.
- 6 replies
Another thumbs up for the feature of being able to save the filter expressions as a prefilter is that this eliminates the need for enabling filtering for all fields in a situation your screen type has limited space for filtering fields. Fe: a screen shows only 4 fields to filter, but I have 20 columns in the list. With filter expressions I am able to use every column without the need to push every column to the screen.
+12On the backlog→Open
+12Status updated to better reflect the Status of the Idea with the clarified Statuses as explained in the Reply here: What happens to your ideas? (updated as per november 2024) | Thinkwise Community
+12Open→Completed
+12This Idea is resolved with the ability to Save advanced filters as prefilters since Platform release 2025.3! With this, it should be possible to reduce the number of pre-defined prefilters in the Software Factory and instead have users create their own prefilters for specific use cases.
Advanced filters are the improved, Universal-specific version of filter expressions. More on it’s use in below blog:
The ability to share prefilters (and other UP settings related to screen state) is something we intend to work on in 2026.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.