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	4273	February 22, 2024
Filter Query result data in Dropdown mapped data source 💬 App Building javascript , sql , component	5	730	May 20, 2024
Dynamically select which column to search in Retool DB 💬 App Building javascript , postgresql	3	1370	June 27, 2023
Dropdown Filter Iterating over Multiple Column Conditions on Table Component 💬 App Building table , dropdown , select	4	110	October 28, 2024
SQL querying to allow dynamic fields 💬 Queries and Resources	4	68	May 22, 2025

Filter a dropdown

Related topics