Filtering by NULL value

I’m trying to create a filter, which compares field value to NULL. I’ve used Equals function, assigned field to the left side and null data constant to the right side. But filter doesn’t yield the expected results. I’ve had a look at created SQL command and the WHERE clause is using = operator. But for comparing to NULL MSSQL server is expecting IS operator. How should I model such filter to receive expected results?

I think, that solution is to leave right side in the filter empty - no parameters, no constant.

Try it.

1 Like

It works as described. Thank you.