Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

8
Replies
3267
Views
 Shubi Yang (ShubiY62) Accenture Senior System Architect
Accenture
JP
ShubiY62 Member since 2016 20 posts
Accenture
Posted: Jul 25, 2017
Last activity: Oct 16, 2018
Posted: 25 Jul 2017 7:10 EDT
Last activity: 16 Oct 2018 12:03 EDT
Closed
Solved

How to expose WorkParty property for reports

Report

Hi,

We have a requirement to show some properties which are in Data-Party class on reports.For example WorkParty(Assignee).pyFullName and WorkParty(Approver).pyFullName

Since those properties are not exposed as DB table columns , so the reports get poor performance of course.

I tried to use optimization tool but it doesn't work, because the Data-Party class is an abstract class.

Could anyone tell me how to expose those properties or is there any other approach to improve report performance with unexposed properties?

Thanks

***Moderator Edit: Vidyaranjan | Updated Categories***


**Moderation Team has archived post**


This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Reporting

Accepted Solution

Posted: 5 years ago
Posted: 25 Jul 2017 8:14 EDT
Nagesha DV (NageshaDV) Coforge DPA Nagesha DV
Coforge DPA
GB
Report

Hi 

There is already Declare Index for the .pyWorkParty() page and "Index class to write" is index-WorkPartyUri. So that you can get the work party details in report by joining with index-WorkPartyUri class, Joining condition could be the pxInsIndexedKey of index-WorkPartyUri class and pzInsKey of Your Work Class. 

Thanks,

Nagesha DV.

Sarna Gupta Srighakollapu
Posted: 5 years ago
Posted: 25 Jul 2017 22:28 EDT
Shubi Yang (ShubiY62) Accenture Senior System Architect
Accenture
JP
Report

Hi,

I tried to join Index-WorkPartyUri class in our reports and it works very well.Thank you very much for the suggestion.

But there is an another issue is that, actually, in order to show the WorkParty Operator's Department information on reports, we added a Single Page property called "OperatorID" in Data-Party class, which Page definition is Data-Admin-Operator-ID. And get the data through .pyWorkParty().OperatorID.pyDepartment. I think it is also needed to add this property in Index-WorkPartyUri class and expose it to column perhaps. But PRPC is not allowing to expose property in Index-WorkPartyUri class by Property Optimization For Report.

Is it possible to expose this department property maually, or has any other way to solve this inssue?
Posted: 5 years ago
Posted: 26 Jul 2017 2:37 EDT
Shubi Yang (ShubiY62) Accenture Senior System Architect
Accenture
JP
Report

I resolved this issue by exposing Data-Admin-Operator-ID.pyDepartment property to DB (Since this class is a Pega shipped class and Pega also not allowing to expose property, I alter PR_OPERATORS table manually by adding column with same name "PYDEPARTMENT" and resaved DB-Table instance , as a result it works well ).And then joined Data-Admin-Operator-ID class to our RD. Now reports get Department data from PR_OPERATORS table PYDEPARTMENT column instand of BLOB, and report performance is been improved 
Posted: 5 years ago
Posted: 4 Aug 2017 14:04 EDT
jun shang (JUNE192011) CIBC
CIBC
CA
Report

Hi,

I have same requirement of you first question. Can you show me how pass the party role in order to get pyFullName for assignee?

 

Thanks lot
Posted: 5 years ago
Posted: 7 Aug 2017 5:44 EDT
Nagesha DV (NageshaDV) Coforge DPA Nagesha DV
Coforge DPA
GB
Report

Hi JUNE192011,

Join your class with Index-WorkPartyUri class, For Joining conditions please check the attachment. 

Thanks,

Nagesha DV.
Posted: 5 years ago
Posted: 8 Aug 2017 8:44 EDT
jun shang (JUNE192011) CIBC
CIBC
CA
Report

Thanks lot. it works for one party. I'm looking for in same row of the report, there are more than one parties need to be displayed.

please advise.

thanks again.
Posted: 5 years ago
Posted: 10 Dec 2017 18:43 EST
Venkat Adusumalli (adusv) PEGA
Pegasystems Inc.
Report

Hi Mate,

Do you got any solution to show two parties in the single row?
Posted: 5 years ago
Posted: 11 Dec 2017 4:30 EST
Lochana Durgada Vijayakumar (Lochan_DV) PEGA Senior Manager, Knowledge Management
Pegasystems Inc.
IN
Report
Hello!
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page.
Show More
Hello!
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
We have also sent you a private message opening up a communication channel in case you have any further questions.
Thanks,

Show Less

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