"On Hold / Waiting" status to be changed to "Investigating" when today's date is the same as "Due Date"
Some of our users enter in a "Due Date" when submitting a ticket, this can be several months ahead of the ticket needing actioning.
The helpdesk engineers will then place that ticket on hold until the due date is reached.
Would it be possible to have a rule that if a due date is set and the status is on hold, then when that day comes it will put the ticket in an investigating status?
This will then email the engineer that this ticket need to be looked at today.
Thanks,
1 Comment
[ + ] Show comment
-
Yes, this should be possible with a rule. You can probably get pretty close using the rules wizard, have you experimented with that? - chucksteel 9 years ago
-
I have worked it out with a little help from local devs and have answered this question, thank you for your help. - chris.poston 9 years ago
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chris.poston
9 years ago
So after using part of the wizard and with a little help from our local dev team. We managed to use this code at the bottom of the "Select SQL":
and ((HD_STATUS.NAME = 'On Hold / Waiting') AND HD_TICKET.DUE_DATE = CURDATE() )
We then add this to the "Update SQL":
update HD_TICKET
set HD_TICKET.HD_STATUS_ID = '83'
where
(HD_TICKET.ID in (<TICKET_IDS>))
We have selected it to run daily at 8am from the Schedule area.
Note:
STATUS_ID ='83' is "Investigating" you will need to change this number for your servicedesk.