Exclamation Mark Operator and Select Component

[thomasatkinson]

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!

[Kabirdas]

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 }}

[thomasatkinson]

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

[thomasatkinson]

Thanks! @Kabirdas