Question
How to Export UI filtered results to Excel
Hi,
I have a repeat grid with data page as source . When user apply any filter on the grid , i want to export the filtered results into excel . I tried using MSOGenerateExcelFile activity . But it is exporting all the results . But am interested in exporting only filtered results. How can i do that.
***Updated by moderator: Lochan to update Categories***
Hi,
If we source Data Page for Repeating Grid and filter the data and export the results to excel it will not work as even though in the UI Filtered results are showing but on the Clipboard all the data will be maintained, due to this all the results will be part of generate Excel. Instead try sourcing the Grid with Report Definition filter the data and pass the RD page to MSOGenerateExcel latest filtered data will be present in the generated Excel.
Thanks,
Chaitanya
As a design policy, Pega decided that we will not retain temporary filters in
1. Save
2. Save-as
3. Export
Since it is subjective, some users may want to filter data in excel as they find it more convenient to filter there.
In this case, the real problem for the user is the number of records that are getting exported.
The number of records to export is configurable and it should limit it to a reasonable number like 10000.
P.S: This requirement is already submitted as an Enhancement Request to fix in future release.