Close popover
Gabriel Bufardeci (GabrielB3483)
Rules Cube

Rules Cube
GabrielB3483 Member since 2017 2 posts
Rules Cube
Posted: August 18, 2017
Last activity: August 21, 2017

Extracting Filtered Workbasket to Excel

So, our client has come with the following requirement: the user must be able to filter the workbasket based on the columns and their values, and then export that same subset of data to a Microsoft Excel file.

The first part is done easily using Pega OOTB functionality, but the problem comes in when we need to extract the filtered data. Is this subset of case data stored anywhere on the clipboard? If so, where is it?

Through some tracing, we've learned that the filter criteria has been saved in pyFilterCriteria, which could technically be used to build a few report definitions used to filter the workbasket for exporting to an Excel document. This could work, but it seems quite a bit more complicated than simply retrieving the data from a data page of the filtered values.

Any help is appreciated, thanks.

***Moderator Edit: Vidyaranjan | Updated Categories***

Reporting System Administration
Moderation Team has archived post