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

 Antonio Amorim (AntonioS0444)
Capgemini
Architect
Capgemini
BR
AntonioS0444 Member since 2017 3 posts
Capgemini
Posted: Jun 26, 2018
Last activity: Jan 7, 2019
Posted: 26 Jun 2018 16:07 EDT
Last activity: 7 Jan 2019 11:56 EST
Closed

Report definition and Real Pagination

I have a doubt Pagination in Report Definition in Pega is Real Pagination?

The database query will take only the number of lines that we define in Pagination?
I didn't find any Pega documentation that defines this type of information.

If is not a real pagination have any way to do that?
If is a real pagination and we use a data page to access this report, the pagination will remain like defined in report definition ok?

Have any way to see the query that was been executed by the report? I dind't find the query in the database trace tool. :(

If anyone has a clear documentation about that would be very helpful to me.

Thanks

***Updated by moderator: Lochan to update platform capability***

To see attachments, please log in.
Reporting

Posted: 6 years ago
Posted: 29 Jun 2018 14:04 EDT
Rett Hean (Rett_Hean_GCS) Principal Software Solutions Engineer
Pegasystems Inc.
US

Try exploring the clipboard and the pyReportContentPage. The pxSQLStatementPost should give you a query to work with, and hopefully help answer some of your questions.

And you may also need to replace the '?'s with the pyPreparedValues found on this page as well.

To see attachments, please log in.
Posted: 6 years ago
Posted: 3 Jul 2018 8:55 EDT
PAWAN B (PAWANB78)
ARETEANS

ARETEANS
IN

Hi,

After running RD, we can see RD SQL query in clipboard at Standard thread level in pyReportContentPage at Code-Pega-List class level. For reference purpose, see the provide screenshot attached.

To see attachments, please log in.
  • Di Smith-Knowles Vijay Tulasi Swarnalakshmi Anbhazhaghan KC Accetta Jaikumar Rajendran and 3 More
Posted: 6 years ago
Posted: 9 Jul 2018 9:07 EDT
Antonio Amorim (AntonioS0444)
Capgemini
Architect
Capgemini
BR

Guys Thanks for your Help,

I had found the pyReportContentPage, everything is ok, but I have one doubt. How Pega works because in the clipboard I only saw 20 registers like I had configured in the pagination but in the sql query I didn't see any script with "limit", "offset" or "rownum".

Anyone knows how Pega make this pagination?

To see attachments, please log in.
Posted: 5 years ago
Posted: 7 Jan 2019 11:56 EST
Marissa Rogers (MarissaRogers)
MOD
Principal Knowledge Management Specialist
Pegasystems Inc.
US
Hello!
 
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query.
Show More
Hello!
 
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s at the top of this screen and also on our Pega Support Community homepage.  Once created, please reply back here with the URL of the new post.
 
We have also sent you a private message opening up a communication channel in case you have any further questions.
 
Thanks,

Show Less
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