Hey,
I’m using variables based where clauses.
however - in case of all
selected I would like to not use the filter at all, as the query translated into large id in (…) filter.
Is there a way to not use the filter in case of ‘all’ selected?
Something like:
WHERE {client_id} IS 'All' OR cte.client_id = {client_id}
in the templating setup, you can choose to include an all
option or not. Have you tried untoggling that button?
@mattabrams Thanks for the answer.
Untoggling the all
button won’t help here as it won’t allow me to query on all the field data, the behavior I’m looking for is to ignore building the where clause when there is no values to filter on (aka all selected)