Specifying a queryable data page
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.
- 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.
- 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.
Previous topic Setting the context of a data page Next topic Specifying a searchable data page