Question
Cognizant
IN
Last activity: 17 Jan 2024 6:24 EST
How to Fetch Filtered results from a GRID layout with pagination enabled whose source is Data Page?
Hi Everybody.
we are using a repeating grid whose source is Data Page. The pagination is enabled.
We wanted to export the filtered results into an excel. I tried with Report definition since the requirement is not possible with Data Page.
Howvere when I am exporting it is only exporting the filtered result from current page as pagination is enabled.
Can someone please suggest if this is possible from data page or Report definition.
Accepted Solution
Updated: 17 Jan 2024 6:24 EST
Cognizant
IN
@MarijeSchillern Thank you for the suggestion. Those changes will require additional configuration. We suggested users to do the filter from excel itself, as they are using the excel very rare.
Pegasystems Inc.
IN
Please go through below link if it helps :
https://support.pega.com/question/how-get-filtered-data-client-side-export-excel
Updated: 9 Jan 2024 6:14 EST
Cognizant
IN
@parav1 I tried that approach ,but I couldn't find the filter values in pyUI pages. The pxRetrieveReportData retrieving all results not the Filtered one
Pegasystems Inc.
GB
@Pooja Dash When using a paginated repeating grid, the export functionality will only export the current page's results. If you want to export all filtered results, not just those on the current page, you might need to use a different approach. One possible solution is to use the 'pxRetrieveReportData' activity to pull all the filtered results onto another page, and then pass these results to the 'pxConvertResultsToCSV' activity. This should allow you to export all filtered results, not just those on the current page. Please note that this approach might require additional configuration and testing to ensure it meets your requirements.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
How to get a full list of Page List data by pxConvertResultsToCSV with pagination
Accepted Solution
Updated: 17 Jan 2024 6:24 EST
Cognizant
IN
@MarijeSchillern Thank you for the suggestion. Those changes will require additional configuration. We suggested users to do the filter from excel itself, as they are using the excel very rare.