Skip to main content
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.
LinkedIn
Copied!

How to use declarative indexes in reports

Summary

Data from indexed embedded properties can be included in reports using the Join feature. This article shows you how to include indexed embedded properties in your reports using the Declarative Index Join feature in list view and summary view rules. For more information about creating declarative indexes, see How to create declarative indexes for embedded properties.

To include indexed embedded properties in a report, associate a prefix with an index definition. Each property in the index definition is then accessible in the other tabs by using the syntax: prefix.indexed property.

Note: Database columns discussed in this article must be exposed to be included in the report. Use the Modify Database Schema Wizard to check for exposed columns. Choose Tools > Database > Modify Database Schema

You can also use declarative indexes in V6 report definition rules. See How to use declarative indexes in report definition rules.

 

Suggested Approach

    1. Create or edit a new list or summary view rule.
    2. Open the Join tab.
    3. In the Declarative Index Join section, enter a text string to be used as an alias in the Prefix field.
    4. In the Index Name field, choose the index definition from the SmartPrompt list. Note that the indexed properties are listed in the SysAdmin category under Declare Index.

    1. Open the Contenttab and, in the Get These Fields section, enter properties, as usual, then properties from the index definition using the syntax, prefix.indexed property.

    2. In the Report Source section, enter a text string in the Content Page Name field.
    3. Enable Read Only.

    1. For list views, open the Display Fields tab and enter the properties, using the same syntax, and labels that you want to display in the report. For summary views, enter the appropriate information in the DrillDowntab.

    2. Open the Organize tab and disable Customize View Button and the Edit? box next to the Excel Button field.
    3. Click the Save toolbar button.
    4. Click the Run toolbar button. The view contains data drawn from the indexed table.

Related Topics

Twenty-seven commonly used JOIN conditions for list view and summary view reports

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community 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
Contact us