Question
Sri Manakula Vinayagar Engineering College
IN
Last activity: 17 Jul 2024 5:30 EDT
Customizing pagination activity
I'm retriving above 50,000 records from db for that its taking time to load harness, in data page i'm using activuty to retrive data,so i decided to use pagination in section it should work like pxAdvancedPaginateForEmployees, on click of page number another new 60 records should retrived, how to achieve this...
Pegasystems Inc.
CA
You can implement OOTB Pagination or Progressive loading in the report definition rule.
Sri Manakula Vinayagar Engineering College
IN
@RameshSangili Thank you for the response yeah i have already enabled that option still its taking time to get load so i thought to add pagination activity in section,but didn't know how to configure that Regards,
Narayanamurthy PS.
Updated: 6 Jun 2024 12:52 EDT
Pegasystems Inc.
IN
@MadhavanS16795014 - To get the records dynamically from the data page call instead of clipboard. If the table source is Data page , In definition tab will have "Allow querying any column (Pega connection only)". This feature will retrieve the records on demand i.e. if first page has 10 records clipboard also holds 10 and clicking on second page it loads next 10 records and clipboard will be updated. It wont load all the records in clipboard.
If the unable to find option "Allow querying" if the platform version is bit older then in load management tab we see "Enable pagination"
https://docs-previous.pega.com/data-management-and-integration/87/specifying-queryable-data-page
Thank you.
Sri Manakula Vinayagar Engineering College
IN
yeah it's fine with data source as report definition...
But in my case i am using activity which retrives 40K records....?
any other solution for this ......?
Thanks
Pegasystems Inc.
IN
@MadhavanS16795014 - Source this activity to the data page and make use of allow querying option to optimize the records in run time.
Thank you.
Sri Manakula Vinayagar Engineering College
IN
Hi Priyanka, thank you for the reply,
i have tried your suggestion but still its taking time to load screen its taking over 30 seconds to get load with data,
and i am looking like there will be any grid regarding activity to add in table layout under specify pagination activity option....
Thank you...
Madhavan S.
Updated: 17 Jul 2024 5:00 EDT
Rulesstack Private Limited
IN
We have multiple approaches for this requirement. One of them is as follows:
1. Use an activity and configure the activity in a data page as a source.
2. Configure a table layout in a section.
3. Set the source of the table layout to the data page.
4. Add pagination to the table layout.
Please check the image below for reference.
Thanks,
Mohd Qizer Uddin
Sri Manakula Vinayagar Engineering College
IN
Yeah, thank you i have enabled that pagination, under that i have to implement pagination activity
after enabiling that checkbox...
Thanks,
Madhavan,