BUG-000162236 for ArcGIS Online

不具合 ID 番号	BUG-000162236
送信されました	October 19, 2023
最終更新日	August 21, 2024
適用対象	ArcGIS Online
見つかったバージョン	June 2023
オペレーティングシステム	Windows OS
オペレーティングシステムのバージョン	11.0 64 bit
ステータス	Will Not Be Addressed

参考情報

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.

対処法

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.