Question
PT Bank Sinarmas
ID
Last activity: 16 Oct 2018 12:03 EDT
How to Show Page Lists on a Report Definition
Hi, I'm in need to make a report definition that looks like this...
as can be seen from the table below, there are 3 pages on Case A's pagelist and there are 2 pages on Case B.
I need to show these pages' property just like the table below.
Is this possible?
If yes, please do give me the step-by-step on how to make it.
Thanks in advance.
|
Case ID |
Property1 |
Property2 |
Property3 |
Property4 |
Pagelist.Property |
|
A |
123 |
23 |
333 |
222 |
Pagelist(1).Property |
|
A |
123 |
23 |
333 |
222 |
Pagelist(2).Property |
|
A |
123 |
23 |
333 |
222 |
Pagelist(3).Property |
|
B |
111 |
222 |
444 |
555 |
Hi, I'm in need to make a report definition that looks like this...
as can be seen from the table below, there are 3 pages on Case A's pagelist and there are 2 pages on Case B.
I need to show these pages' property just like the table below.
Is this possible?
If yes, please do give me the step-by-step on how to make it.
Thanks in advance.
|
Case ID |
Property1 |
Property2 |
Property3 |
Property4 |
Pagelist.Property |
|
A |
123 |
23 |
333 |
222 |
Pagelist(1).Property |
|
A |
123 |
23 |
333 |
222 |
Pagelist(2).Property |
|
A |
123 |
23 |
333 |
222 |
Pagelist(3).Property |
|
B |
111 |
222 |
444 |
555 |
Pagelist(1).Property |
|
B |
111 |
222 |
444 |
555 |
Pagelist(2).Property |
**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.
BUPA
AU
Hi Michael,
I think for this requirement you have to create a declare index for your page list. This will expose the Pagelist repeating data onto a table.
Next the report definition shown above should join the index table to display the data in the required format. There is an option to do joining in Report Definition with declare index.
Pegasystems Inc.
GB
As Swarendu says, you will need to create an index on the embedded properties so that the data is exposed in a database table. Are you using Pega 7? This can be done automatically by using the Property Optimization tool. If you right click on the Pagelist(1).Property in the app explorer you should see an option "Optimize for reporting". More details can be seen in this help article:
Exposing properties and populating database columns using the Property Optimization tool
Once this has been done, you need to configure a declarative index join in the Data Access tab of the report definition.
PT Bank Sinarmas
ID
Hi MarcAlderman_GCS,
yes I'm using Pega 7.1.9, I've tried to "Optimize" the property, I opened the Data Class, then open the property, clicked on Action, then click on "Optimize for Reporting" but it says this (attached)
Pegasystems Inc.
US
Hi Michael,
You shouldn't optimize it from the Data Class. You have to ideally do it from the class where the Report Definition is present.
Let's say Class A contains the Report Definition, the same class contains the Page list property as well. You have to right click the properties you need in the page list and click on optimize.
Hope this helps.
--Ravi.
PT Bank Sinarmas
ID
Hi Ravi,
I've just tried it, and still shows the same error as the one I uploaded. Is there any other suggestion you might want to share?
Thank you in advance.
--Michael
PT Bank Sinarmas
ID
Hi Ravi,
I'm trying to optimize property of a page list I made in a work Class, referencing to a Data Class.
what's an example of "something provided OOTB"?
thanks.
--Michael.
Pegasystems Inc.
US
Hi Michael,
If the Page list is created by you and the work class is concrete, it shouldn't throw you any error.
--Ravi.
PT Bank Sinarmas
ID
Hi Ravi,
I just checked the work class, and it's concrete. The page list is also created by myself, yet it still throw that error, this is why I'm confused and looking for reasons that might cause this error, or if there's any requirements or restrictions on optimizing a property.
Thanks.
--Michael.
Pegasystems Inc.
US
Hi Michael,
It shouldn't throw you an error then.
You can always create the index class trigger and the columns in the database manually. But that is a lot of manual tasks. If it is not that big of an issue you can manually create those. But you have to follow the manual process for this page list in future as well. Hence I wouldn't recommend it.
Please raise an SR as this seems to need further investigation.
--Ravi.
Pegasystems Inc.
IN
Hi Michael,
Please let us know if you do log an SR for this and its ID. That way we can track it and follow-up this discussion with the resolution.
Thank you,
Updated: 4 Jul 2017 2:18 EDT
Pegasystems Inc.
IN
Hi Michael,
As listed in the screenshot, you might need to reach out to a colleague or Pega Account Administrator to move ahead.
This article provide details on Account Administrators - How to check your Account Administrator details on My Support Portal
Refer the following article to learn how to log an SR.
Introduction to My Support Portal: Opening a Support Request. |
Hope this helps.
TATA Consultancy Services Ltd
US
Did you find solution for the same? I'm having same requirement of displaying pagelist content in table and not able to implement.
Please respond with the solution if the issue is resolved for you. Many Thanks.
Pegasystems Inc.
US