Select to view content in your preferred language

"is not blank" filter not working

638
1
09-23-2020 02:18 PM
PiaotianJin
Emerging Contributor

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
Frequent Contributor

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