Posted: 18 Jun 2019 12:19 EDT Last activity: 24 Jun 2019 9:35 EDT
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.
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.