Question
6
Replies
783
Views
Zensar Technologies
Posted: June 18, 2019
Last activity: June 24, 2019
Closed
SQL function alias not visible in report viewer
I have created a custom SQL function alias for datetime data type. However case manager is not able to see the custom function name when adding datetime column into report viewer. Case manager can can see system default functions like day, day of week, day of month etc. Please advise.
Hi,
Thanks for posting your question in Pega Support Community.
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://pdn.pega.com/sites/pdn.pega.com/files/help_v72/procomhelpmain.htm#rule-/rule-alias-/rule-alias-function/main.htm
Let me know if this helps.
Thanks.