Question
1
Replies
470
Views
TCS
Posted: March 13, 2018
Last activity: March 14, 2018
Closed
To fetch range of rows and display it in repeating list.
Hi All,
My Requirement is , we need to fetch first 500 records and display in repeating list using pagination. If user clicks page number 491-500 through pagination , then we need to fetch another 500 records, again if user clicks page number 991-1000, then again fetch 500 records.
This basically to reduce the load of the system.We are using DB2 table from where we need to fetch records and display.
Could please guide me how to proceed the above requirement.
Thank you.
To display the data, it's probably easiest to use a grid with paging enabled: https://pdn.pega.com/presenting-grid-results#paginating-results
As for sourcing the data, the path of least resistance is probably to use a Report Definition, since that should have "Enable Paging" turned on by default: https://pdn.pega.com/sites/pdn.pega.com/files/help_v721/procomhelpmain.htm#rule-/rule-obj-/rule-obj-report-/rule-obj-report-definition/reportviewertab.htm