Question1Replies162Views×Close popoverNaveen Mekala (NaveenM4289) HSBC HSBC IN View Profile NaveenM4289 Member since 2015 40 posts HSBC Posted: January 20, 2016Last activity: January 20, 2016Posted: 20 Jan 2016 0:43 ESTLast activity: 20 Jan 2016 0:49 EST Closed Solved How to report data from Archive table of different schema?Hi Team,We are using pega 6.1 SP2. We have a requirement to report the data from Archive table.Archive table is in different schema with no details of Work class other than PYID and Blob columns. Is there any way can we report from Blob column?We thought of below options1. Changing the Primary Work Class to Archive Table and run the List View report to fetch data from Archive and then revert back to original.Cons: This inhibits the production users to work as it causes the main work objects be saved in archive table if users work on.2. Retrieve archived data back to the main work table and run listview and re-archive the retrieved work items.Cons: Retrieving archive items bring all dependent data instances be retrieved into other tables which would cost a performace issue.Is there any approach would you suggest us? Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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: 5 years agoPosted: 20 Jan 2016 0:49 EST×Close popoverRajiv Nistala (nistr) PEGA Senior Manager - Engineering Pegasystems IN View Profilenistr PEGA replied to NaveenM4289Would it be possible to create a new class (inheriting from your work class but mapped to this new table) and then run reports of it?