Question

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

Comments

Keep up to date on this post and subscribe to comments

Pega
September 13, 2019 - 11:56am

Hi Pavan

Please see this PSC post. It may answer your question.

https://community1.pega.com/community/pega-support/question/how-export-ui-filtered-results-excel

 

Pega
September 13, 2019 - 2:39pm

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.

September 14, 2019 - 9:47am

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