Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Fetching all records from external table for loading in RD



User is pulling the data from an external table, since the number of records are large, they were unable to pull data more than 100K. If one tries to pull using RDB-List method, PRPC thread hangs. User queries for solution to pull the data when it is more than 800k and traverse over it and use it with some pagination? Or, do we have to pull data multiple times, like 100K each time?


Following steps describe implementation of Pagination using an Activity -
  1. Create an Activity (chkaPaginationPaterntActivity).
  2. Set a Property (Integer) as counter and have a for loop in the Pre-Condition step.
  3. Set the index number in the Property-Set step and call another activity (ChkPagination) where you have configured the Report Definition. (You can call the Report Definition in the same activity).

Step-2: Parameters and Pages & Classes tabs of the Activity:

Step-3: chkPagination Activity:

Step-4: Parameters and Pages & Classes tabs of the Activity:

Step-5: Report Definition : chkRD

On running the chkaPaginationPaterntActivity activity, it calls the Report Definition. User can process each records within the For Loop of this activity by retrieving the pxResults() from the Clipboard.

Some More queries:
User came up with below queries:

When we run the RD, it is going to override the fetched results as per the page records we have specified in the Activity?
Answer: Yes

Does the RD is going to fetch all records at a time or is it going to fetch records of each page and fetch the next set of records?
Answer: It will fetch once, we access the pages as per the defined index.

After the completion of the RD, does the records are going to stay in Clipboard? User need to remove them explicitly?
Answer: Yes. User have to delete it explicitly. And, if we have 38 records, and we are fetching 5 records per page, then in my 8th page of the Report, we would have pxResults(1),(2) and (3) with the actual results. pxResults(4) and (5) would be empty.

Published January 31, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration 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.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us