Currently, the default of a Lookup function is to return the input value if you leave this field blank. You can enter #space to return a blank value (" "). However, I would like it to return NULL.
In subsequent groovy functions you can just write:
if (Lookup) { return Something; } // meaning the Lookup found something.
instead of if (Lookup != " ") { return Something; }
ADMIN RESPONSE
Jan 10, 2023
Thanks for the idea. We have recently shipped this in the latest release of Jedox. Please check it out and tell us what you think!
You can now enter "#null" as the default value in a lookup function.
