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.h…

Let me know if this helps. 

Thanks.

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.

Can anyone help me to solve this issue?

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.

Hi Vimal,

Do let us know if you end up creating an SR.

Regards,