Management would like to track small issues that are usually resolved quickly on first contact (like password resets).  They would like me to set up a rule to insert a record into the HD_WORK table for all tickets in a specific queue to for 5 minutes of work.  Is it even possible for the update statement box to contain a mysql insert statement?

Thanks.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0
You should not have to use insert for this.

use an update and set statement to set the HD_WORK.ADJUSTMENT_HOURS to 0.08 for the ticket. 
(5min/60min = 0.083333)
Answered 06/11/2015 by: h2opolo25
Red Belt

  • Scratch that. Just tested it and it won't work with the set statement.
Please log in to comment
0
Just tried the following in my test system and it worked.....(sorry for re-answer but comment formatting sucks)

select * from HD_TICKET
where HD_TICKET.ID = 394


INSERT INTO HD_WORK (HD_TICKET_ID, USER_ID, MODIFIED, ADJUSTMENT_HOURS)
VALUES(<TICKET_IDS>, 1444, NOW(), 0.23)

Make sure you include the USER_ID or else it will show in the table but won't show in the GUI, change your select and insert statements accordingly and most importantly do not blame me if it messes things up. TEST on a test VM before implementing anything in production.


Answered 06/11/2015 by: h2opolo25
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity