Question
1
Replies
357
Views
Knowledge Experts SA
Posted: February 5, 2016
Last activity: August 26, 2020
Closed
Solved
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Accepted Solution
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.
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.