Question
Knowledge Experts SA
FR
Last activity: 26 Aug 2020 8:17 EDT
The result of concatenate function is null if 1 parameter is null
Hello,
We are using concatenate function in a report definition. When one parameter is null the result of the concatenate function is null. How can we change that to return at least the second parameter concatenate to space if the first parameter is null?
Thanks,
Accepted Solution
Updated: 9 Feb 2016 11:57 EST
You may be able to take care of this by defining your own version of the concatenate function as a custom function alias (SQL type, not Java). The source for the FA is basically a fragment of SQL, which means you can use IF-THEN or CASE statements. I can send you an example if you'd like (once I dig it back up).
Here's a screen shot of a function alias I created for a different issue:
The FA rule has to have an applies to class of Embed-UserFunction in order to be interpreted as an SQL function alias. You can have your 2 properties as the input parameters, and arrange the SQL code to test for null on either value (or both for that matter) and format the result accordingly.