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