/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: AmberSDNB 2 weeks ago
Blue Belt
0

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.

Posted by: Hobbsy 1 week ago
Red Belt
0

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.

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ