Moving ticket to another queue, need some help with Status
I figured out how to move a ticket to a new queue but i cannot get Status to show up correctly
Select SQL:
SELECT HD_TICKET.ID
FROM HD_TICKET
JOIN HD_STATUS ON HD_TICKET.HD_STATUS_ID = HD_STATUS.ID
WHERE HD_TICKET.TITLE LIKE 'Testing queue move Open Status%'
AND HD_TICKET.HD_QUEUE_ID = 12
AND HD_STATUS.NAME = 'New'
AND TICKET_TEMPLATE_ID = '0'
Update SQL;UPDATE HD_TICKETSET HD_QUEUE_ID = 79, HD_STATUS.NAME = 'New', TICKET_TEMPLATE_ID = 0 WHERE ID IN (<TICKET_IDS>)
Thank You
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
AmberSDNB
2 weeks ago
Posted by:
Hobbsy
1 week ago