Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Exposing embedded properties

Updated on April 5, 2022

You can expose only top-level Single Value properties as columns. However, you can expose embedded properties using one of the following methods.

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 report needs to select rows based on property pyWorkPage.pxFlow("LoanDisburse").Sheet.Detail(4), complete the following steps:

  1. Create a 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 Type set 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 report definition rule.

Declare Index approach

Use this approach if some or all values of a Value List or Value Group are needed as exposed columns.

  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. This rule runs immediately, adding and deleting instances of the new class.
  5. Expose the database columns corresponding to the Index- class.
  6. Reference the Index- properties in the report definition rule.
  • Previous topic Exposing properties using the Modify Schema wizard
  • Next topic Populating properties by using the Column Populator tool

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us