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
PNJ
12/17/2020, 9:49 PM
NULL is special in SQL. You probably want something like
case when {createdfrom} is null or {createdfrom}='' then ... else ... end