Change Queue based on Category
SELECT HD_TICKET.ID, HD_TICKET.TITLE,
JOIN HD_CATEGORY ON (HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID)
WHERE HD_CATEGORY.NAME rlike 'File::Access'
AND HD_TICKET.HD_QUEUE_ID = 9
ORDER BY HD_TICKET.ID
UPDATE HD_TICKET, HD_CATEGORY
SET HD_TICKET.HD_QUEUE_ID = 17
WHERE HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID
AND HD_TICKET.ID =
Now I'm just testing this as is and it worked once. I added my changes, and the log states it worked fine but the ticket did not change queues. I removed my changes and remade the query to the base you see above and now it wont move anything.
I have it set to run on ticket save, new tickets and old tickets will not move. The log states it updates the tickets, and that I've set a custom comment yet no comment is made or movement of ticket despite having the correct category.
01/17/2017 11:25:15> Starting: 01/17/2017 11:25:15 01/17/2017 11:25:15> Executing Select Query... 01/17/2017 11:25:15> selected 1 rows 01/17/2017 11:25:15> Adding ticket comments... 01/17/2017 11:25:16> updated 1 tickets 01/17/2017 11:25:16> Executing Update Query... 01/17/2017 11:25:16> updated 1 rows 01/17/2017 11:25:16> Ending: 01/17/2017 11:25:16
Should I restart my k1000?
Be the first to answer this question