Data Cleansing: reset Ticket Due Date

MS1Corp

We're on V1.18.2.

Our data entry clerk errantly modified the original DUE DATE on a few tickets by mistake.

We need to set the DUE DATE back to the value that it was before the mistake.

We know this isn't possible in the UI. Are we able to do this safely through the DB? IOW, are there any dependencies that we should be aware of before we attempt this change?

Thank you

I'm tagging this as a "migration" because its the type of problem normally experienced during a migration, even though we did it on the UI.

KevinTheJedi

MS1Corp

Nah there’s only one place to update it, the _ticket table.

Cheers.

MS1Corp

Ok, we set the ticket's SLA to None in the UI, then we updated the due date in the DB.
We don't rely on SLA notifications (for the system to compute and send interim notices) at the moment, so this seems safe for the small amount of data we cleansed.
Thanks!