BUG-000097404 for ArcGIS Online

Bug ID Number	BUG-000097404
Submitted	June 24, 2016
Last Modified	July 5, 2023
Applies to	ArcGIS Online
Version found	4.2
Operating System	Windows OS
Operating System Version	8.1
Status	Known Limit

Workaround

Incorrect results are returned when filtering empty strings using the is blank and is not blank filter expressions in Web AppBuilder for ArcGIS because the filter setting is not properly configured.

The example uses a list of 28 attractions in New York City; 22 of which have the Review column filled while six others remain blank. However, the image below shows only four features are returned when the Review is blank expression is used.

Results of the wrong filter setting.

The following are best practices to ensure correct results are returned when filtering empty strings using the is blank and is not blank filter expressions in Web AppBuilder for ArcGIS:

Enable one filter at a time
In Web AppBuilder for ArcGIS, filtering can be applied from the attribute table using the Filter widget. Enable either one of the filters at a time to return the correct result.

Only use one filter at a time.

Uncheck the 'Enable Filter by map extent by default' option
When configuring the Attribute Table widget, uncheck the Enable Filter by map extent by default option in the Configure Attribute Table dialog box.

Uncheck the Filter by map extent option.

Uncheck the Filter by map extent option.

Note:
As an alternative, open the attribute table and click the blue-colored Filter by map extent icon  to disable the function. Clicking this icon turns the color of the icon to black. This indicates the filter is working on the total data instead of at a certain extent.

Enable the Filter result from the slider
By default, the Filter result is not shown automatically on the map. To view the Filter result, click the Filter widget and slide the Filter slider

to the right.

This is the Filter slider.

Use the 'is blank' or 'is not blank' selection from the drop-down list
In the Configure Filter dialog box, filter the blank value by selecting the is blank or is not blank option from the second field (operator) drop-down list, instead of selecting is or is not in the second field (operator) and typing blank in the third field (value/field/unique).

Select the 'is blank' and 'is not blank' options.

Select the 'is blank' and 'is not blank' options.

Configuring the Filter settings properly returns the correct results, as described below:

Configuring the Review is blank expression returns six features, as expected.
Configuring the Review is not blank expression returns 22 features, as expected.

Additional Information

This is as designed. When the field value is empty string (white-space), it is not treated the same as null. Make sure blank fields are actually null, and not empty string.

Steps to Reproduce

Bug ID: BUG-000097404

Software:

ArcGIS Online

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

When using the filter expressions 'is not blank' or 'is blank', the filter does not give the correct result in ArcGIS Online Map Viewer.

Workaround

Additional Information

Steps to Reproduce

Related Information

Discover more on this topic