Question
1
Replies
2059
Views
Sberbank
Posted: April 18, 2017
Last activity: April 19, 2017
Closed
How to get all rows from Page list and convert them to CSV utilizing pxConvertResultsToCSV.
I have a Repeat grid layout, as a source is Report definition. The grid displays twenty row per page. So, if there are thirty-three rows, there are four pages.
I have got a task to export all grid's data to CSV. I have found out the pxConvertResultsToCSV activity. It requires to pass PageList with the properties to convert. I use pgRepPgSubSectionMySectionListB.pxResults to do this. But I have realized, that the property pxResults contains only first twenty elements of pgRepPgSubSectionMySectionListB. But I must export to CSV all the rows. How can I reach this? Thank you.
***Moderator Edit: Vidyaranjan | Updated Categories***
Hello,
I think the your grid source data from report defination.
1.Use progressive paginatin in the grid.
2.Disable pagination in the report defination(Not a good practice, as it might overload the clipboard)
3. Set the maximum number of rows to retrieve to your required number in the report defination.
Now you should get more results in the page list.
Thanks,
Saikat