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.