Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Bhowmick Reshmi (RESHMI406)
Wells Fargo

Wells Fargo
IN
RESHMI406 Member since 2010 4 posts
Wells Fargo
Posted: Feb 27, 2019
Last activity: Feb 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

To see attachments, please log in.
Reporting

Posted: 6 years ago
Posted: 27 Feb 2019 11:34 EST
Ron Lee (RonLee_GCS) Principal Software Solutions Engineer
Pegasystems Inc.
US

I believe you have been misinformed. Paging does not limit the result set to the "page size" number of records. In order to do this, the system would have to keep the DB connection open and maintain a cursor, which it cannot do. The model that the system uses is to obtain a connection from the connection pool, execute a query, then return the connection to the pool.

As far as I know, SQL does not have a syntax that supports paging (i.e., get records N through M from a result set where N and M are arbitrary integers).

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center 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