Scripting : Moving ticket to another queue, need some help with Status

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

Be the first to answer this question

Answer this question

Scripting Questions

question