"is not blank" filter not working

520
1
09-23-2020 02:18 PM
PiaotianJin
New Contributor II

I have a text field, and I want to only show not blank records. But when I set "is not blank" in filter, it's not working. Anyone has any ideas?

0 Kudos
1 Reply
JayJohnsonWashoeCounty
Occasional Contributor III

Typically this would happen if you have fields which appear blank, but are actually either NULL or contain a non-visible character (like a space).  Try adding to your filter to exclude NULLS and " " and see if that helps.

Jay

Jay
Washoe County GIS