MSOGenerateExcelFile : Filtered data not exported to excel instead all records exporting to excel.
Hi,
I have requirement to export the filtered data but MSOGenerateExcelfile is exporting whole data. Its not exporting only filtered data.
Pls suggest.
Soruce To MSOGenerateExcelFile :- DataPage is the source for MSOGenerateExcelFile
Pega Version : 8.3
Cheers-
Pavan
Pegasystems Inc.
US
Hi Pavan
Please see this PSC post. It may answer your question.
https://collaborate.pega.com/question/how-export-ui-filtered-results-excel
Pegasystems Inc.
US
According to my research, MSOGenerateExcelFile will not export the filtered grid data for either Property or Data Page sources. It apparently does so only when the source is a Report Definition, and then only if "Specify custom results page" is checked.
There are no OOTB options that affect this behavior, so unless you can use the above Report Definition option, you will not get filtered results in your exported Excel file.
Pegasystems Inc.
IN
Hi @I'mPavan,
Your requirement to export the filtered data is not currently supported. This is a requirement and not a bug. In your use case of using MSOGenerateExcelFile , there is no work around that would help us.
The filters are lost when exported because they are for temporary viewing.
An enhancement request, FDBK-30554 ,has been created for consideration by Pega Product Management.
Regards,
Priyabharathi