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.…

How to show data with empty filter

Oleksandr_Dovgopol May 14, 2023, 7:01am 2

Topic		Replies	Views
Show all data when a filter is not in use + Use arrays in queries 💬 App Building sql , table	2	902	June 10, 2024
Querying MultiSelect Dropdown not returning data if no values selected 💬 App Building	7	4361	August 1, 2023
Multiple dynamic filters in tables 💬 App Building	4	1393	August 3, 2023
How do I dynamically filter by multiple dropdown boxs - WILL THIS WORK? 💬 Queries and Resources javascript , sql , postgres	2	4199	July 27, 2023
Filtering Table According Selected Dropdown Options 💬 App Building easter-egg-hunt	6	3272	May 27, 2024