Like COALESCE function in JSL
I have been looking for the function with which we could have an alternative value(e.g. A) if the column X is null, like COALESCE function, and the equation could be something like:
COALESCE(:X, A)
if X is not null, then it return the value of X
if X is null, then it return the value A
I understood that we manage to have such results by having a bit complicated equation, but I was wondering if w...