Question

10
Replies
5111
Views
 Prasanna Kumar (PrasannaK8545)

IN
PrasannaK8545 Member since 2015 15 posts
Posted: February 17, 2016
Last activity: March 1, 2016
Posted: 17 Feb 2016 21:21 EST
Last activity: 1 Mar 2016 7:59 EST
Closed

Optimizing Page List Property?

Hi Guys,

I have few questions about Optimizing a Page List Property but not single valued properties.

1. Is there a wizard that runs like single valued property optimization for Page List Property or we have to manually take forward the process?

2. How to check if the Page List is Optimized? Can we view the pagelist property in corresponding table.

Any help would be appreciated, please do not blindly suggest me to go through the pdn material. That did not help me out fully.

Anything with screenshots would be appreciated, if someone has time.

Thanks in advance.

Prasan

System Administration Case Management Data Integration Reporting Decision Management
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: 5 years ago
Updated: 5 years ago
Posted: 17 Feb 2016 22:48 EST
Updated: 17 Feb 2016 22:50 EST
Murali Kakarla (Muralik7)
Infosys

Infosys
AU

1. from PDN can see that wizard exists in 5.4 but I do not see such option in 7.1.7: https://pdn.pega.com/how-create-declarative-indexes-embedded-properties

2. One way to check if page list is optimized is to search for Declare Index rules with source page context as pagelist property name and of course matching applies-to class.

You can refer to OOTB Rule- . Warnings declare index rule. This is created to optimise or index pxWarnings pagelist in rule data. The Index class Index-Warning in this case is mapped to its dedicated table (pr_index_warnings) so as to facilitate reporting.

     AUT01.png

Hope these details helps you!

Murali...
Posted: 5 years ago
Posted: 19 Feb 2016 19:40 EST
Prasanna Kumar (PrasannaK8545)

IN

Hi Murali,

You are right, in 7 i did not see any wizard for optimizing the pagelist yet. Waiting on Joe's response to know how to consume the hot fix that they have used.

Thanks for responding.

Prasan
Posted: 5 years ago
Posted: 18 Feb 2016 5:17 EST
Joe Abi Sleiman (JoeAbiSleiman)
Murex

Murex
LB

What Pega version are you on?

If you mean you're trying to optimize properties of embedded page lists, you might have to install a hotfix. We're on 7.1.7 and we had to install a hotfix to be able to optimize properties within page lists of page lists. The procedure is a regular one, you just right click on the property of the page list that you want to optimize and click on "Optimize for Reporting". The system will create a Declare Index rule and will also create a separate table for that Page List in your database. So for instance if you have a Page List called Employees and within it you have another page list called Addresses that has certain properties on it and you optimize any of these properties, the Delcare Index rule will by default be called Index_Employees_Addresses. In your database however, by default these records will be mapped to the table pr_index. If you wish to see them in a dedicated table, then you have to manually create the Declare_Index mapping.

On the other hand, if you are trying to Optimize properties within a Page List (not embedded page lists), then you should be able to do so directly.

Or do you mean that you want to optimize the entire page list without having to go through optimizing each and every property individually?

Maybe you could post some screenshots for us to better clarify?

Thanks,

Joe
Posted: 5 years ago
Posted: 19 Feb 2016 19:38 EST
Prasanna Kumar (PrasannaK8545)

IN

Hi Joe,

Nice to hear that, I am using 7.1.6. I still might have to use the hot fix for this version as well because there is no "Optimize for reporting" option on the property right click.

How do we consume the hotfix on to our environment?

Thanks for prompt response.

Prasan
Posted: 5 years ago
Posted: 22 Feb 2016 7:54 EST
Joe Abi Sleiman (JoeAbiSleiman)
Murex

Murex
LB

Hello Prasanna,

The error typically in this case is not that the 'Optimize for Reporting" option doesn't exist or show; rather, you do have the option but you cannot proceed in the wizard configuration till the end. Normally when you right click on a property and can't find the option to optimize it means that the property has already been optimized before (at least this is the case in 7.1.7). Can you post some screenshots so that we may be able to understand better?

(You can check if the property is optimized or not either by looking for it in your database in the table pr_index, or more easily by going to Designer Studio > System > Database > Column Population Jobs).

Thanks,

Joe