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
Answers (2)
Have you tried the built in Choose Action -> Move to Queue feature? It retains whatever the current status is. Not sure what you're trying to accomplish exactly with the status, but maybe this will help you avoid SQL all together.
So you need to make sure you set it to the correct Status I’d for the queue receiving the ticket.
If You run a report of all records in the HD_STATUS table
SELECT* FROM HD_STATUS
you will see every status in every Queue, and you need to set HD_TICKET. HD_STATUS_ID to the correct ID value, simple.
