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

01-18-2023 05:09 AM
Labels (1)
New Contributor III


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



0 Kudos
0 Replies