This might be in another question but I couldn't find it. Is there a way to create a custom ticket rule to email a supervisor for a ticket that has been unassigned for say 3 days or so?
Answer Summary:
Cancel
1 Comment   [ + ] Show Comment

Comments

  • Yes, this is possible. I'm away from the office today but I'll try to post tomorrow.
Please log in to comment

Answer Chosen by the Author

0
This query will find tickets that are open and unassigned that were created over three days ago:
SELECT "user@email.com" AS NOTIFY, HD_TICKET.* FROM ORG1.HD_TICKET
WHERE OWNER_ID = 0
and TIME_CLOSED = "0000-00-00 00:00:00"
and TIME_OPENED > '3 days';
Change the user@email.com to the user that you would like to notify. You can create a new rule that uses this SQL query. Check the box to Email each recipient in query results and then specify NOTIFY as the Column containing email addresses. You can use the ticket columns as variables in the message, e.g. $title, $summary, etc.

This query does not join to any tables so if you want to include submitter names and such it will have to be modified.

Answered 08/27/2015 by: chucksteel
Red Belt

  • awesome...thank you. I'll give it try next week.
Please log in to comment

Answers

Answer this question or Comment on this question for clarity