Question

1
Replies
107
Views
Bhowmick Reshmi (RESHMI406)
Areteanstech

Areteanstech
IN
RESHMI406 Member since 2010 4 posts
Areteanstech
Posted: February 27, 2019
Last activity: February 27, 2019
Posted: 27 Feb 2019 4:07 EST
Last activity: 27 Feb 2019 11:34 EST
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.