Differences

This shows you the differences between two versions of the page.

--- support:re-add_deleted_form_in_ticketer [2019/02/01 16:44] – pmurphy
+++ support:re-add_deleted_form_in_ticketer [2021/06/25 10:09] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+===== Re-Insert Ticket Form =====
+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 tickt_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>;

Internal Errigal Collaboration Wiki