How to get a full list of Page List data by pxConvertResultsToCSV with pagination
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.
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,
Accepted Solution
Updated: 1 Oct 2022 0:29 EDT
JPMC
IN
IT Solution Service
SG
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,
IT Solution Service
SG
No, this question is about how to export to CSV, not Excel or PDF.
@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.