Querying existing / missing values¶
There are two ways of querying missing values:
The exists- and notExists-filters is the recommended and most efficient way of query for missing values
This method is not as efficient as using a filter, but if you need to do this within a query-expression, you could use the “LIKE” function with an all-expression:
myValue LIKE "*"
publish.first NOT LIKE "*"