Function Alias Not Appearing in Report Definition
Hi,
We need to do more advanced formatting of column values in report definition.
When I read the Help of Function Alias, it sounds like it is supported in RD.
But for example, the OOTB Function Alias rule (below) is not appearing in RD's Calculation Builder.
Is this a defect or an expected behavior? Ideally, we'd like to create a new FA (which then uses a Java function) and use in RD.
Thanks,
Will
Accepted Solution
Pegasystems
IN
Function Alias will only appear in Report Definition if they are defined on the class Embed-UserFunction. They are SQL snippets which can leverage the SQL functions in the database for filtering or formatting.
https://community.pega.com/sites/default/files/help_v72/procomhelpmain.htm
Pegasystems Inc.
US
Just to add to this, you can only use function aliases that relate to SQL functions in the calculation builder. If you try to save a Java based function alias into the Embed-UserFunction class, you'll get a validation error.
Infosys Limited
IN
Where referenced
Java alias functions can be used in collections, report definitions, decision trees, when condition rules, Declare Expression rules, and constraints rules.
SQL alias functions rules support the development of report definitions.
Verramobility
US
From the help of 7.2.2:
Where referenced
Java alias functions can be used in collections, decision trees, when condition rules, Declare Expression rules, and constraints rules.
SQL alias functions rules support the development of report definitions.