Hi I am new to Retool! I am trying to filter a form component dropdown (EID) based on the previous two dropdowns that contain first and last name. Currently it is only filtering on the first name and returning those EIDs . I am open to any suggestions. Thanks in advance. [image]

[image] spatel: select eid from roster where {{ !select1.value }} OR first ILIKE {{ '%' + select1.value + '%' }} AND {{ !select2.value }} or last ILIKE {{ '%' + select2.value + '%' }} Ahh I think you might need some brackets to specify the logic a bit more clearly for SQL. Try this: sele…

Filter a dropdown

💬 Queries and Resources

dcartlidge August 3, 2023, 4:50pm 2

welcome to the community - can you share the code that's displaying the list of dropdown options?

Solution Challenge August 2023 in our Retool Developer Community Forum!

Topic		Replies	Views
Dynamic Filtering of Mapped Values 💬 Queries and Resources javascript , sql	6	3956	February 22, 2024
Filter Query result data in Dropdown mapped data source 💬 App Building javascript , sql , component	5	653	May 20, 2024
Dynamically select which column to search in Retool DB 💬 App Building javascript , postgresql	3	1336	June 27, 2023
Multiple dynamic filters in tables 💬 App Building	4	1211	August 3, 2023
SQL querying to allow dynamic fields 💬 Queries and Resources	3	29	April 17, 2025

Filter a dropdown

Related topics