Unique value NULL

[ChrisGordon]

When I 'Get Unique Values' for a field in Query Builder one of those values that shows is NULL, yet when I I set that field equal to NULL it tells me 'no records returned'. If no records returned then why does it show NULL as a unique value, and how can I eliminate NULL from the list of unique values? I don't really want it there.

[ChrisSmith7]

Are you sure you're using the ArcGIS JavaScript API for this and not the query builder in ArcMap? You have this posted in "ArcGIS Server with JavaScript API". Also, when testing for null, it's not "<> null" or "= null", it's "is not null" to exclude and "is null" to include.

[ChrisSmith7]

Oh, and the reason for this is because null is not a value... you can't compare something that's not a value to another value, hence, why x = null can never be true.