An expression of non-boolean type specified in a context where a condition is expected, near 'or

Queries and Resources
,
2

This actually does seem to be an issue with MS SQL syntax:

1804×790 61.1 KB
1810×618 57.9 KB
A workaround something like this seems to work:

select * from products
where ( {{ selSearchProductType.value || null }} IS NULL OR product_type_id = {{selSearchProductType.value}} )

2 Likes