We have a dashboard which reports on the main Work Table and gets the count based on a column values , we are in the process of archiving the work table periodically and store it in cloud Repository, so is there any way to report on the archived data and retrieve values from particular column (application specific exposed columns) .
Has anyone done reporting over the Archived Data? We are using Pega V8.3.
***Edited by Moderator: Pallavi to update platform capability tags***
Thanks for your answer , i had gone through the post , it mentions creating new table and store the data and report on that, which we want to avoid (creating a new table) , is there any way to run report on Archived Data and get those columns.
The files containing the data will be in a zip format and stored in Repository, each time archival job runs , a file will be generated with archived data with the timestamp, the format is something like this format : FileName_GMTTimestamp.zip