Selecting multiple prefilters now always leads to: where [prefilter 1 query] AND [prefilter 2 query]. I would also very much like to have the possibility to make OR prefilters.
Not only between columns (colour = red OR shape = square) but also within columns (colour = red OR colour = blue OR shape = square).
You could require locked prefilters to be always true and then, on top of that, have one or multiple 'or-prefilters'. It would generate a query like this:
But it is the responsibility of the developer to make sure that the 'or-prefilters' will not result in situations that show too much data.
Another challenge is how to indicate that multiple active prefilters need to be combined with an OR- or AND-operator. Should this be determined by the user? For instance by being able to group multiple non-locked prefilters as 'or-prefilters'. Or should 'or-prefilters' always be predetermined, logical groups? In which case we could simply add an 'operator' field to prefilter groups in the SF.
Could we combine this with a 'mandatory' property for a prefilter-group? Always have at least one prefilter from within a group active?
Mandatory exclusive prefilter groups will be available in 2019.2. The release should be available for download next week.
Also agreed.
I can imagine having them ‘fixed’ would be the easiest option to implement. I agree with Robert Jan on this.
In the GUI we want users to filter multiple sales orders (not ‘between’ but separated different sales orders). In our old ERP this is easily done by choosing ‘in’ as our filter. In the Thinkwise GUI there are a lot of options we never use in the standard filter but we really miss this ‘in’ filter where we can fill in those order numbers. A normal sql statement would then do ‘where sales_order in (123, 567, 999, etc). I am not sure if the idea where you are working on, does also make this possible? Otherwise: should I post this as a new idea?
Hi@Hugo
This idea focusses on having the ability to have AND prefilter groups and now also OR prefilter groups. This has effect on how the prefilters will be applied in the GUI.
The IN filtering, you could use OR prefilters for that too, but for now you can use Excel style filtering for that. Feel free to create a new idea for this. Please add the use case and how you would like to see it work in the GUI.
Hi@Mark Jongeling
Thank for your reply! I have just created a new idea: