Sonia Tse (SoniaT29)

SoniaT29 Member since 2015 4 posts
Posted: February 20, 2016
Last activity: June 14, 2016
Posted: 20 Feb 2016 7:05 EST
Last activity: 14 Jun 2016 6:49 EDT

Exposing an embedded property

I am using Pega 7.1.8.  I am reading the help on how to expose property and it mentions that the optimizing for reporting tool can only expose property on the top level.  And any embedded property, it can only be done manually by the following steps:

Copy approach — Copy the value to a new top-level property each time the embedded property changes (or each time the instance containing the property is saved). For example, if a list view report needs to select rows based on property pyWorkPage.pxFlow("LoanDisburse").Sheet.Detail(4), you can:

  1. Create a new top-level Single Value property to hold a copy of this value.
  2. Create a one-step activity to copy the value to the new top-level property, with Activity Typeset to Trigger.
  3. Create a Declare Trigger rule that calls the activity each time the work item is saved.
  4. Expose the top-level property.
  5. Reference the top-level property in the list view rule.

Declare Index approach — If not one but many or all values of a Value List or Value Group are needed as exposed columns, a Declare Index rule is a better approach.

  1. Create a concrete class derived from the Index- base class.
  2. Create Single Value properties in the new class to hold values of the embedded values.
  3. Create a Declare Index rule with the appropriate embedded Page Context value that copies the embedded values into a new Index- instance.
  4. Save the Declare Index rule. It executes immediately, adding and deleting instances of the new class.
  5. Expose database columns corresponding to the Index- class.
  6. Reference the Index- properties in the list view rule.


However when I right click on the property, I can see the optimizing property option, does it mean I can use to wizard to optimize the property without going through the above steps?  Or the wizard will complete the above tasks automatically?

Which way is the better way to do this?  

Data Integration
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 Discussion, please write a new Discussion.