Exclamation Mark Operator and Select Component

Queries and Resources
1

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!

image
image2960×308 80.5 KB

2

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

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

4

Thanks! @Kabirdas