Filter Query: fieldname is NULL or fieldname is '' (empty but not null)

LarsChristianØstgaard — Wed, 18 Jan 2023 13:11:27 GMT

It seems like the query i Experience Builder is blank only filters fields that is NULL and not empty fields..?

I want to build filters by querying on both if a field is NULL OR a fields is "" (empty but not NULL))

I need to create a filter query like this SQL syntax:

select * from table where (fieldname IS NULL OR fieldname = '')

Using fieldname is blank only gives me the NULLs and not fields that is empty but not NULL.

How can I filter a field that is empty but not NULL??

Please see the attached image

Appreciate all help

Regards

Lars

topic Filter Query: fieldname is NULL or fieldname is '' (empty but not null) in ArcGIS Experience Builder Questions