Question
Capgemini
BR
Last activity: 7 Jan 2019 11:56 EST
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***
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.
Pegasystems Inc.
IN
Adding to Rett’s view, you can open the pyReportContentPage in the standard thread .
Thanks,
Arun
INCESSANTTECHNOLOGIES
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.
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?
Cognizant
IN
Anyone got the answer for this ?
Pegasystems Inc.
US