Hi everyone,
I have a doubt on how to set the query for the advanced search (highlighted in red).
With text fields it’s easy as the “contains” filter allows me to filter null or filled values.
In the case of a non-mandatory select whose value is an integer id related to another table, how can I discard the filter if the user does not select a value?
You have to add a condition statement. Click on the ? and then add the same field name. That will let it slide by if there isn’t a value in the field.
1 Like
But on a numeric field if I pass a null value what type of condition should I set?
Hey @enriweb77,
Just like Baub pointed here…
So, in the above example the conditions will take place only if the GET parameters are set
*In some cases you better work on groups because you will be able to adjust the condition per parameter or group of parameters
1 Like