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

242
0
01-18-2023 05:09 AM
Labels (1)
LarsChristianØstgaard
New Contributor III

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

0 Kudos
0 Replies