KACE Product Support Question
Automatically change to 2nd queue if a certain category is selected
I am trying to get tickets moved, on ticket save, automatically if a certain category is selected.
This is this code I'm using:
SELECT HD_TICKET.ID, HD_TICKET.TITLE,
JOIN HD_CATEGORY ON (HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID)
WHERE HD_CATEGORY.NAME like '%IT Project%'
AND HD_TICKET.HD_QUEUE_ID = 1
ORDER BY HD_TICKET.ID
UPDATE HD_TICKET, HD_CATEGORY
SET HD_TICKET.HD_QUEUE_ID = 2
WHERE HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID
AND HD_TICKET.ID in (
This is the output log I get which shows no errors:
30/05/2017 15:03:20> Starting: 30/05/2017 15:03:20 30/05/2017 15:03:20> Executing Select Query... 30/05/2017 15:03:20> selected 2 rows 30/05/2017 15:03:20> Executing Update Query... 30/05/2017 15:03:20> updated 0 rows 30/05/2017 15:03:20> Ending: 30/05/2017 15:03:20
If anyone could point me in the right direction it would be much appreciated.
For further info I've also tried with the following update query which I believe should just change the queue but get the same output log as above.
SET HD_QUEUE_ID = 2
WHERE ID in (