BUG-000162236 for ArcGIS Online

Bug ID Number	BUG-000162236
Submitted	October 19, 2023
Last Modified	August 21, 2024
Applies to	ArcGIS Online
Version found	June 2023
Operating System	Windows OS
Operating System Version	11.0 64 bit
Status	Will Not Be Addressed

Additional Information

This is an expected behavior in SQL. It might logically make sense to have the null values returned but SQL behaves differently. NULL indicates that the value is unknown and is different from an empty or zero value. No two null values are equal. Comparisons between two null values, or between a null value and any other value, return unknown because the value of each NULL is unknown. As a result, null values always coerces to FALSE as a boolean.

Workaround

As of August 2024, this workflow is possible in ArcGIS Online Map Viewer using the Condition groups. Conditions can be added to the same group through the three dot menu in the top right corner. New groups can be added through the 'Add new' button at the bottom of the pane. In the map below, the visible points include both points with null values and those that match the 'is not' condition for the Country field.