Hi guys! I have such query in my app which uses dynamic data from two filters.
SELECT
contacts.*
from
contacts
JOIN agencies ON contacts.agency_id = agencies.id
WHERE
(
{{!filterAgency.value}}
or contacts.agency_id = {{filterAgency.value}}
) AND contacts.provider_id IN ({{ filterProviders.value }})
First condition
(
{{!filterAgency.value}}
or contacts.agency_id = {{filterAgency.value}}
)
allows me to show all data if filter is empty.
But I cant't understand how to do the same with second one. I mean how to show all query data if {{ filterProviders.value }} is empty? Any ways I tried didn't help me(