Under the Results subtab of saved search, is it po...
# general
l
Under the Results subtab of saved search, is it possible to use a CASE formula like: CASE WHEN THE {CREATEDFROM} IS EMPTY THEN..... I tried to use NULL or = '' but both of these result to invalid expressions
p
NULL is special in SQL. You probably want something like
case when {createdfrom} is null or {createdfrom}='' then ... else ... end
l
Thanks, I'll try null.