Dear Support,

Today we realized, that enabling new feature AutoArchive is good for perfomance, but eliminate possibility to create reports by archived requests.

It there is any possibility to select requests also from archived requests? Or recover all requests back to normal state?

Thanks beforehand..

Here is my query used for report:

SELECT rctd.FIRST_NAME "Technician",rc.MM2COMPLETEREQUEST "Time Elapsed",rc.EXECUTEDTIME "Executed Time" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID INNER JOIN RequestCharges rc ON wo.WORKORDERID=rc.WORKORDERID LEFT JOIN RCTechnicianIDs rct ON rc.REQUESTCHARGEID=rct.REQUESTCHARGEID LEFT JOIN SDUser rcti ON rct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID WHERE (((rc.EXECUTEDTIME >= 1277931600000) AND ((rc.EXECUTEDTIME != 0) AND (rc.EXECUTEDTIME IS NOT NULL))) AND ((rc.EXECUTEDTIME <= 1285880399000) AND (((rc.EXECUTEDTIME != 0) AND (rc.EXECUTEDTIME IS NOT NULL)) AND (rc.EXECUTEDTIME != -1)))) AND wot.THD_WOID=wot.WORKORDERID ORDER BY 3