A customer sometimes asks for a deleted NOC Form to be re-added to a ticket.

When a form is deleted an active boolean in the ticket_change table is set to false.

The steps to re-add a form are:

• Find the relevant ticket_change ID using the ticket_id field and contents field to identity correct form.
• Update the ticket_change entries active boolean to 1.
• Refresh ticket and deleted form should be visible.

Example Queries:

select * from ticket_change where ticket_id = <ticket ID> and contents like 'ExteNet NOC%';  
update ticket_change set active = 1 where id = <ticket_change ID>;