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.
- In the navigation pane of Dev Studio,
click Records.
- Expand the Data Model category, and then click
Data Page.
- Click the row of a data page that you want to open.
- 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.
- Click Save.