Skip to main content

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

Specifying a queryable data page

Updated on April 6, 2022

Improve performance for data pages that are used as the source of a table by designating the data page as queryable. The data page then loads only the necessary rows from the table. When you configure a queryable data page, you can filter columns, and sort and group data.

Before you begin: To specify a queryable data page, you must set the following parameters on the Definition tab of the data page rule form:
  • Structure – Set to List
  • Mode – Set to Read-only
  • Scope – Set to Thread or Requestor
  • Data source – Set to Report definition
    Note: The Report definition must be in the same class as the data page. You can add multiple Report definition sources.

    You can define multiple sources in the data page, but at least one source must be a Report definition. However, run-time behavior might be inconsistent because you might not know which source the system will run.

    If you configured a response data transform or post-load activity to change the values returned by the Report definition, the grid might not display the values as expected.

For more information, see Creating a data page.
For example, you view a table of 10,000 customers who live in California. You filter the Location column to show only those customers who live in Sacramento, which displays 20 results on your screen. If you configured your data page to accept API queries, the data page only loads the 20 results that you see, and not all 10,000 results.
  1. In the navigation pane of Dev Studio, click Records.
  2. Expand the Data Model category, and then click Data Page.
  3. Click the row of a data page that you want to open.
  4. On the Definition tab, in the Query Options section, select the Allow querying any column (Pega connection only) check box.
    This check box enables the filtering, sorting, and grouping of data when the data page is queried by the /data_views REST API.
  5. Click Save.

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