Question
1
Replies
357
Views
Knowledge Experts SA
Posted: February 5, 2016
Last activity: August 26, 2020
Closed
Solved
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,
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
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.