Posted: 14 Jul 2020 1:27 EDT Last activity: 14 May 2021 3:09 EDT
Report Definition not fetching all the records from the table without pagination
We need to query around 80,000 of data from DB and process those records alos export the data into excel as well, we have used Report Definition to fetch the values, we are able to fetch the entire records when we use Pagination enabled, but for our legacy application needs an entire data result set to copy into another page reference to process the data, we are not able to fetch more than 10,000 records without pagination. We are getting timed out ,same for export to excel as well more than 10,000 records count to load we are getting timed out.
We have updated the Reports Settings(DesignerStudio->Reports-Setting) and in Report Definition Data Access tab as well.
Maximum number of rows to retrieve 50000
Maximum elapsed time (in seconds) for database query 300
Please provide any suggestion for the above need, we are using Pega 7.4 version.
Thanks for your suggestion,Yes we are able to fetch more than 50K of records from DB view, but the same amount of data we are not able to display it in excel and pdf when we select export to excel and export to pdf.
In report setting its 200000 for retrieve and Maximum elapsed time gave 300 number of rows export at a time 5000.
below the Maximum record count were displayed in excel and pdf.
For Export to Excel : 10,000
For Export to PDF : 4,500
Is there any option to retrieve entire data into excel and pdf.