Select to view content in your preferred language

Attribute Query "Is not equal to" doesn't recognize Null

6092
11
11-01-2022 10:42 AM
Status: Closed
Labels (1)
Jon-PaulMcCool
Occasional Contributor

When doing an attribute query and using the Is Not Equal To operator, the result does not include Null values. For example, I have a series of parcels with a given identifier, and when trying to select those without the identifier, I was getting no result since all those without the identifier were Null. I know very well that I can just select the Null options, but if a user wanted all values other than X and needed that to include Null, and they did not know that the operator did not work with Nulls, that could be an issue. Just seems that Nulls should be included in the operator's ability to discriminate.

11 Comments
DougBrowning

I hit this today too.  Should be fixed.