How to show data with empty filter

App Building
,
1

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(

2

This article solved my problem
Querying MultiSelect Dropdown not returning data if no values selected

3