Search for Empty Strings

Discussion created by boyle.matt on May 26, 2020

Is it possible to search/filter for empty strings in the Portal/AGO map viewer?


We are using ArcGIS Enterprise 10.7.1 and have text fields that contain empty strings.  I can't find a way to search/filter these values.  An empty string is not the same as a NULL value, which can be filtered using "is blank".

While we could calculate all these fields to NULL since this particular field is nullable, what if it were a text field that did not allow NULL values?


Any ideas/thoughts/suggestions are welcome.  Thanks!