Hi Tyler, hi Rahul
Thank you both for your answers.
A variable can’t be null and that’s why the function ISNULL() doesn’t work with variables. A variable can just be empty. So, if we are working with variables we have to write:
’VARIABLE’ = ''
Maybe I’m not explaining myself well, but that’s not what I mean, Rahul. What I intend to do is apply a filter only if something happens. For example, I want to apply a filter to the CASES.CASE_ID column only if my variable is not empty.
CASE WHEN ‘VARIABLE’ != ‘’ THEN CASES.CASE_ID = ‘…’ END
I do not know if Celonis has this functionality implemented. If I can solve this problem, I’ll put the solution here.