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.