If none of the existing archive sets meet your needs, please contact AgileAssets for further assistance.
The following example shows the level of detail and complexity required to archive data, which emphasizes why it is imperative that AgileAssets' staff be involved in the creation of new archive sets. In this example, old equipment repair orders are archived, where "old" is defined as all repair orders with repair order IDs less than 1000.
Table Name | Archive Count | Order | Archive WC |
WORK_ORDERS_LABOR_DC | 0 | 1 | WORK_ORDER_ID IN ( SELECT w.WORK_ORDER_ID FROM WORK_ORDERS w, SETUP_PROJECT p WHERE p.PROJECT_ID = w.PROJECT_ID AND p.PROJECT_ID < 1000 and p.MODULE_ID = 5 ) |
WORK_ORDERS_MATERIAL_DC | 0 | 2 | WORK_ORDER_ID IN ( SELECT w.WORK_ORDER_ID FROM WORK_ORDERS w, SETUP_PROJECT p WHERE p.PROJECT_ID = w.PROJECT_ID AND p.PROJECT_ID < 1000 and p.MODULE_ID = 5 ) |
WORK_ORDERS | 0 | 4 | WORK_ORDER_ID IN ( SELECT w.WORK_ORDER_ID FROM WORK_ORDERS w, SETUP_PROJECT p WHERE p.PROJECT_ID = w.PROJECT_ID AND p.PROJECT_ID < 1000 and p.MODULE_ID = 5 ) |
EQUIPMENT_REPAIR_DIRECT | 0 | 3 | PROJECT_ID < 1000 |
SETUP_PROJECT | 0 | 5 | PROJECT_ID < 1000 and MODULE_ID = 5 |