topic Re: Filter Feature Layer for null values in ArcGIS Online Questions

Filter Feature Layer for null values

sgambrel_Bouldercounty — Wed, 29 Jun 2022 15:52:20 GMT

Looking to filter a Feature Layer to show only features with null / no data values from a text field, but cannot figure out how to do so.

Basically trying to create a map that will be used by a field editor, showing them which features need to have data entered. Once they add a value to the field, it will then disappear from the map. This should be easy, right?

Re: Filter Feature Layer for null values

DarrellHill — Wed, 29 Jun 2022 16:00:57 GMT

If I'm understanding you correctly, and if it's SQL based, your definition query should be;

<DATAFIELD> IS NULL

Can't use <DATAFIELD> = NULL

Re: Filter Feature Layer for null values

DataOfficer — Wed, 29 Jun 2022 16:03:51 GMT

Two options if you are wanting to filter within the map, or filter the entire layer itself through a View. If you go the 'view' route, this link is also useful: https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/introducing-the-new-create-and-update-view-layer-experiences/

In both instances, the filter expression will be something like 'FieldName' 'is blank'.

Re: Filter Feature Layer for null values

sgambrel_Bouldercounty — Wed, 29 Jun 2022 16:11:13 GMT

I'm using the Classic Map Viewer, so IS is the only applicable operator. I tried every combination of NULL, <NULL>, etc. and unfortunately that doesn't work.

Re: Filter Feature Layer for null values

sgambrel_Bouldercounty — Wed, 29 Jun 2022 16:14:33 GMT

I would like to filter in the map - how would I do so?

A View might work but is unnecessarily cumbersome.

Re: Filter Feature Layer for null values

DataOfficer — Wed, 29 Jun 2022 16:21:27 GMT

In the 'is' dropdown in the middle, there should be an 'is blank' option.

Re: Filter Feature Layer for null values

sgambrel_Bouldercounty — Wed, 29 Jun 2022 16:31:34 GMT

A ha! That worked! Thanks, I did not see the "Is Blank" down the list - I really figured that "Is" was going to be the operator. Thank you.