Question

4
Replies
7445
Views
 Anupam Kumar (AnupamK1)
HCL Technologies
Technical Architect
HCL Technologies
NL
AnupamK1 Member since 2016 1 post
HCL Technologies
Posted: October 5, 2016
Last activity: June 27, 2017
Posted: 5 Oct 2016 14:38 EDT
Last activity: 27 Jun 2017 12:19 EDT
Closed
Solved

Increase Max Records in Report Definition

Hi

I see that Report Definition queries maximum 500 records at a given time.

How can I increase this limit to query all the records in database table..?

Low-Code App Development 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.
Posted: 4 years ago
Posted: 5 Oct 2016 15:36 EDT
Anupam Kumar (AnupamK1)
HCL Technologies
Technical Architect
HCL Technologies
NL

I know this but my question is different. Say I have 10K records in a table and this table grows in size gradually over time. How would I make I sure that report queries all the records and not just a hard coded value e.g. 10K

Accepted Solution

Posted: 4 years ago
Posted: 7 Oct 2016 7:36 EDT
Rajiv Nistala (nistr)
PEGA
Senior Manager - Engineering
Pegasystems
IN

Please take care of the performance overhead of bringing all the records in memory.


You can always set the "Maximum number of rows to retrieve" in the Data Access tab of report definition rule to 0 (zero) to return all the records.
Posted: 4 years ago
Posted: 6 Oct 2016 15:49 EDT
Ashish Agrawal (AGRAA)
PEGA
Technical Lead
PEGA
IN

Hi, In that case, just enable pagination in your report. whne pagination is enabled, then max row count is ignored an dit will pull all records unless timed out due to very very high no of records ... so you may have to optimize that if needed.