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).
+21
+23
+5select some_values
from some_table t1
where locked_prefilter = 'true'
and ( first_or_prefilter = 'true'
or second_or_prefilter = 'true'
);
+5
+14
+5+9As far as security goes, I agree with Robert Jan's solution that locked/hidden prefilters should always be applied to the query and can only be combined with an AND-operator.
Vincent Doppenberg wrote:
Also agreed.
I think AND/OR concepts are hard enough for a user, so I'd suggest have them 'fixed' in a predetermined group.
Robert Jan de Nie wrote:
I can imagine having them ‘fixed’ would be the easiest option to implement. I agree with Robert Jan on this.
+9
+4In 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?
+23Hi
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.
+9+9Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
