Filter a dropdown

Queries and Resources
1

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

2

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

3

select eid from roster
where {{ !select1.value }} OR first ILIKE {{ '%' + select1.value + '%' }}
AND
{{ !select2.value }} or last ILIKE {{ '%' + select2.value + '%' }}

4

@spatel if the table is small enough, one easy workaround would be to query the entire table on load, then use a JS transformer to filter the values for the EID based on the values of the first couple selects and have that transformer become the source of your EID dropdown.

5

Ahh I think you might need some brackets to specify the logic a bit more clearly for SQL.
Try this:

select eid from roster
where (
( {{ !select1.value }} OR first ILIKE {{ '%' + select1.value + '%' }} )
AND
( {{ !select2.value }} or last ILIKE {{ '%' + select2.value + '%' }} )
)

2 Likes
6

Thanks @dcartlidge, worked like a charm!

2 Likes