Question
Zensar Technologies
IN
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.
Pegasystems Inc.
IN
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.
Let me know if this helps.
Thanks.
Zensar Technologies
IN
thanks for the reply but it does not solve my problem. I want it to have appeared in report viewer so that user can use it. please see attached ss
Zensar Technologies
IN
thanks for the reply Tarad. I have already defined it under Embed-UserFunction.
The issue is not regarding the report definition, (its already appearing there) but..
It is not appearing in report viewer when case manager edits any report and tries to add a column which contains datetime data.
Please see attached screenshots where I want to have this function so that users can use it.
Zensar Technologies
IN
Can anyone help me to solve this issue?
Pegasystems Inc.
IN
Hi Vimal,
I see that these are getting populated from step5 of 'pzCreateColumnPageWrapper' activity. I did try private edit to add my custom functions, it worked.
But the activity is final, also I don't see any extension point for this activity as well.
You can raise an SR to get an extension point for the activity.
Thanks.
Pegasystems Inc.
IN
Hi Vimal,
Do let us know if you end up creating an SR.
Regards,