topic Query for nonexisting values in DQL

Query for nonexisting values

000panther — Mon, 25 Sep 2023 10:49:39 GMT

I want to find items where a specific field is not existing. How can I do that with DQL?

Something like

fetch events
| filter myItem.nonexisting == null

000panther — Mon, 25 Sep 2023 10:50:48 GMT

A colleague pointed out the isNull function to me. The syntax is

fetch events
| filter isNull(myItem.nonexisting)

And this also works when the field does not exist.