Question

1
Replies
104
Views
RESHMI406 Member since 2010 4 posts
Areteanstech
Posted: February 27, 2019
Last activity: February 27, 2019
Closed

Pagination on BackGround

Hi,

Can someone please explain how pagination in a report definition work at background? If I enable Paging and keep Page size 10 I understand pega fetches 10 records. When I click page 2 pega fetches the next 10 records. However the Post query generated remains same in the pyReportContentPage.

Eg:

SELECT "PC0"."pyID" AS "pyID" , "PC0"."pzInsKey" AS "pzInsKey" , "PC0"."pyStatusWork" AS "pyStatusWork" FROM PEGADATA.pc_XX_XX_XXX_Work "PC0"

I understand the purpose of Pagination, just need to understand how is pega fetching the result set.

Thanks,

Reshmi

Reporting
Moderation Team has archived post
Share this page LinkedIn