Table of Contents

Troubleshooting - How to delete a wrong ticket

Author: Yanjun Wang

Request

Part of PM of Poles project

Delete all the old PM of Poles tickets on QA. 

Solution

From database:

1. delete all the form entries from related form tables based on change_id
2. delete all the Ticket Change entries for forms from ticket_change table based on the ticket_id
3. delete all the attachments entries from uploadable_file table and ticket_uploadable_file based on ticket_id
4. delete all the Ticket Status entries from ticket_status based on the ticket_id
5. delete other related entries, like emails
6. delete the ticket from ticket table