View and Trigger Updates for Responder

The steps below need to be completed according to whether you use Oracle or SQL Server in order to get updates to a View and a Trigger related to the new Incident Review tool. This only has to be done once, so if you completed it at 10.6.1a, you don't have to complete it again at 10.6.1b.

For Oracle:

To update the View the following steps need to be performed: 

1. Open the oracle database in Oracle SQL Developer.
2. Connect to your Responder database.
3. Open Views.
4. Right-click RX_INCIDENTS_VIEW then click edit.
5. Add ir."USER_REVIEWED" after ir."VOLTAGE"
    
6. Click Test Query to ensure the query is successful.
   
    
7. Click OK.
   
    

To update the Trigger the following steps need to be performed: 

1. Open Triggers.
2. Right click RX_INCIDENTS_TRG and click Edit.
3. Add user_reviewed after voltage in each of the insert statements. Insert :new.user_reviewed in the ‘INSERT’ and ‘UPDATE’ value statements. Insert :old.user_reviewed in the ‘DELETE’ value statement.
   

 

For SQL Server:

1. Open the database using Microsoft SQL Server Management Studios.
2. Navigate to Tables and open RX_INCIDENTS table.
3. Open the triggers folder under the RX_INCIDENTS table.
4. Right-click rx_incidents_trg and click modify.
5. Insert user_reviewed column to the insert and select statement for the insert trigger.
   
   
6. Insert the user_reviewed column to the insert and select statement for the delete trigger.
   
   
7. Insert the user_reviewed column to the insert and select statement for the update trigger.
   
   
8. Execute the query with the changes above.