Support: Restoring a Deleted Operation

This article applies only to Bundle-Track versions 3.6 and higher.

To preserve the integrity of historic production details, Operations that have been deleted from the Operations List are not lost until all related Cuts are also deleted and purged, and the database is compressed. Until that happens, you can restore a deleted Operation with the following procedure.

Requirements:

• The Operation's exact Code.
• Administrative access to IB Console

Procedure:

1. Get ISQL ready to run your commands.
   • If you don't know how, click here to learn, and then return.
      
2. Copy and Paste the following code into ISQL:
   

   Update OPR set ACTIVEINFO = 'T' where OPRLAB = 'CODE'; Commit;

   
    
3. Edit that statement, replacing the word CODE with the actual Operation Code.
   (Keep the single quotes around that Code value.)
    
4. Click the Lightning Bolt icon to execute and note the result.
   • If the code executes successfully, it will simply disappear from the upper window.
   • If you get an error message, contact Bundle-Track support.
      
5. Exit ISQL and IB Console.