Long Term Device Updates for Responder

The steps below need to be completed according to whether you use Oracle or SQL Server in order to get updates for Long Term Device functionality added at 10.6.1b.
To update the following steps need to be performed: 

For Oracle:

1. Open the oracle database in Oracle SQL Developer.
2. Connect to your Responder database.
3. Open Triggers.
4. Right click RX_INCIDENT_DEVICES_TRG and click Edit.
5. Insert long_term_status after remarks in each of the insert statements. Insert :new.long_term_status in the ‘INSERT’ and ‘UPDATE’ value statements. Insert :old.long_term_status in the ‘DELETE’ value statement.
   
   
6. Right Click in the editor and choose compile (Ctrl + F8).

 

For SQL:

1. Open the database using Microsoft SQL Server Management Studios.
2. Navigate to Tables.
3. Find the RX_INCIDENT_DEVICES table.
4. Open the triggers folder under the RX_INCIDENT_DEVICES table.
5. Right click the rx_incident_devices_trg and click modify.
6. Insert the ‘long_term_status’ column to the insert and select statement for the insert trigger.
    
    
7. Insert the ‘long_term_status’ column to the insert and select statement for the delete trigger.