Filter a dropdown

[dcartlidge]

@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:

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