Question
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***
Adding to Rett’s view, you can open the pyReportContentPage in the standard thread .
Thanks,
Arun
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.
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?
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.