Skip to main content
Contact a Moderator

Question

6
Replies
1082
Views
 Vimal Soni (Vimal Soni) Zensar Technologies Software Engineer
Zensar Technologies
IN
Vimal Soni Member since 2016 11 posts
Zensar Technologies
Posted: June 18, 2019
Last activity: June 24, 2019
Posted: 18 Jun 2019 12:19 EDT
Last activity: 24 Jun 2019 9:35 EDT
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.

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
Posted: 18 Jun 2019 12:35 EDT
Debraj Tarafder (tarad1) PEGA Senior Pega Support Associate
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.

https://community.pega.com/sites/default/files/help_v72/procomhelpmain.htm

Show More

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://community.pega.com/sites/default/files/help_v72/procomhelpmain.htm

 

Let me know if this helps. 

 

Thanks.


Show Less
Posted: 2 years ago
Posted: 19 Jun 2019 1:39 EDT
Vimal Soni (Vimal Soni) Zensar Technologies Software Engineer
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
Posted: 2 years ago
Posted: 19 Jun 2019 1:34 EDT
Vimal Soni (Vimal Soni) Zensar Technologies Software Engineer
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.

 
Posted: 2 years ago
Posted: 24 Jun 2019 7:12 EDT
Sreepriya Rao Gona (Sreepriya) PEGA Senior Technical Solutions Engineer
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.
Posted: 2 years ago
Posted: 24 Jun 2019 9:35 EDT
Lochana Durgada Vijayakumar (Lochan_DV) PEGA Senior Manager, Knowledge Management
Pegasystems Inc.
IN

Hi Vimal,

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

Regards,

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice