Exclamation Mark Operator and Select Component

Hi there, my query for my select component works fine until I add the '!' operator so that I don't have to have a selected option. Advice welcome!

Hi there @thomasatkinson!

Are you using MSSQL? It seems like it might not support booleans. Can you try this instead?

Select * from Projects
WHERE 1 = {{ !select1.value ? 1 : 0 }}
OR ProjectSubType = {{ select1.value }}

Hi @Kabirdas thanks yes MSSQL so of course - doesn't like booleans. The above worked once I put brackets after the where clause.

Thanks! @Kabirdas