GabrielB3483 Member since 2017 2 posts
Rules Cube
Posted: 3 years ago
Last activity: 3 years 1 month ago

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
Share this page LinkedIn