- Edited
I have a need to be able to update a ticket number after it has been opened. This will allow me to match a ticket number from another system. Is there anyway to do this easily?
Modify a Ticket Number After It Has Been Opened
- Edited
I'm not aware of any way to do that in the UI.you would have to edit the database directly.
21 days later
@ACC626 I have done simular mod with task number.
I have created a trigger that updated task number with ticket's number + department name :
BEGIN
IF NEW.object_id > 0 THEN
SET @ticketnumber = (SELECT number FROM ost_ticket WHERE ticket_id = NEW.object_id) ;
SET @teamsinto = (SELECT name FROM ost_department WHERE id = NEW.dept_id) ;
SET NEW.number = CONCAT(@ticketnumber,'.', @teamsinto);
SET NEW.flags = 0;
SET NEW.closed = NOW();
END IF;
END