Hi
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
