Question

3
Replies
396
Views
 Pavankumar A S (I'mPavan)
Atos Syntel
Pavankumar A S
Atos Syntel
IN
I'mPavan Member since 2013 11 posts
Atos Syntel
Posted: September 13, 2019
Last activity: September 14, 2019
Posted: 13 Sep 2019 1:01 EDT
Last activity: 14 Sep 2019 9:47 EDT
Closed

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

Low-Code App Development Case Management Reporting User Experience
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 1 year ago
Posted: 13 Sep 2019 14:39 EDT
Ron Lee (RonLee_GCS)
PEGA
Principal Software Solutions Engineer
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.
Posted: 1 year ago
Posted: 14 Sep 2019 9:47 EDT
Priyabharathi Ayyasamy (Priyabharathi)
PEGA
Technical Solutions Engineer
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