Hi,
Could anyone please tell me if it’s possible to combine boolean expressions inside of if_then_else expressions?
For example
test
if_then_else(isNull(A) and isNull(B), ‘foo’, ‘bar’)
is not accepted, and neither is
test
if_then_else(isNull(A), if_then_else(isNull(B), ‘foo’, ‘bar’), ‘bar’)
Otherwise, we can do the “and” operation in the database.
Kind Regards,
Lazar