How to get a full list of Page List data by pxConvertResultsToCSV with pagination

User Experience
,
1

Hi,

I am facing an issue. Please help.

I am using pxConvertResultsToCSV activity so end user can download a CSV file out of a Page List data on screen. Now, I have set Report Definition for the source of Table, and also I’ve enabled pagination in the Table as below.

Report Definition.png
Report Definition.png718×479 24.3 KB

Pagination enabled.png
Pagination enabled.png730×173 7.19 KB

In this case, although I have plenty of data in a list, downloaded CSV file will contain only 10 rows, the first page. The issue is actually exactly the same as this post https://support.pega.com/question/how-get-all-rows-page-list-and-convert-them-csv-utilizing-pxconvertresultstocsv. Unfortunately there was no real solution in there. I need to accomplish both pagination and downloading full list. Can anyone please show a workaround?

Regards,

2

@CloeW938 Since you might have used Call pxConvertResultsToCSV in an activity to export results to CSV, can you make use of Call Rule-Obj-Report-Definition.pxRetrieveReportData activity to pull the results on to another page so that all results can be pulled and can be passed on to pxConvertResultsToCSV there by overcoming the few results exported to CSV.

There is another configuration which might work - Use data page instead of report definition both on UI and to pass pxConvertResultsToCSV but drawback is you will have all the results on clipboard page even though used pagination.

3

@CloeW938 Have you tired making use of ootb activity “pzRDExportWrapper” to export the report contents either into a excel or pdf?

4

@SanthoshRanga

Thanks, I was able to get a full list by your approach. The Page List already exists by Report Definition defined in the Table on a section rule, and calling Rule-Obj-Report-Definition.pxRetrieveReportData on another page is a bit wastful as we are basically running a query twice, but looks like this approach at least resolves the issue. Thank you for sharing your insight! This is very helpful.

Thanks,

5

@BhanuPrakash_G

No, this question is about how to export to CSV, not Excel or PDF.