/build/static/layout/Breadcrumb_cap_w.png

I need a ticket rule that re-opens a ticket when the submitter responds after it has been closed

At the moment, when the submitter of a closed ticket replies to that ticket, it does not re-open the ticket, nor alert the owner. This means comments following ticket closure are missed. Is there a rule that can be created to make the closed ticket re-open and alert the owner once a comment is made but not the user satisfaction survey?


Thanks in advance!


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: jfrank 9 years ago
Blue Belt
1
New ticket rule from Service Desk > Configuration > Rules > New (SQL):

Select SQL:

select distinct HD_TICKET.ID, 
               HD_TICKET.OWNER_ID as OWNER_ID, 
               HD_TICKET.ID as TICKNUM, 
               HD_TICKET.TITLE,
               HD_STATUS.NAME AS STATUS_NAME,
               HD_STATUS.STATE as STATE,
               OWNER.USER_NAME as OWNER_NAME,
               OWNER.FULL_NAME as OWNER_FULLNAME,
               OWNER.EMAIL as OWNER_EMAIL,
               UPDATER.USER_NAME as UPDATERNAME,
               UPDATER.EMAIL as UPDATEREMAIL
          from (HD_TICKET, HD_STATUS)
     left join HD_TICKET_CHANGE on HD_TICKET_CHANGE.ID = <CHANGE_ID>
     left join HD_TICKET_CHANGE_FIELD on HD_TICKET_CHANGE_FIELD.HD_TICKET_CHANGE_ID = HD_TICKET_CHANGE.ID
     left join USER OWNER on OWNER.ID = HD_TICKET.OWNER_ID
     left join USER UPDATER on UPDATER.ID = HD_TICKET_CHANGE.USER_ID
         where HD_STATUS.ID = HD_TICKET.HD_STATUS_ID
           and HD_TICKET_CHANGE.HD_TICKET_ID = HD_TICKET.ID
           and HD_TICKET_CHANGE_FIELD.FIELD_CHANGED !='SATISFACTION_RATING'
           and HD_TICKET_CHANGE_FIELD.FIELD_CHANGED !='SATISFACTION_COMMENT'
           and HD_STATUS.STATE = 'closed' 
           and (UPDATER.ID <> OWNER.ID or OWNER.ID is NULL) 
           and UPDATER.ID > 0

-----

Select Append comment to ticket (if you'd like) and enter whatever information you want).
Select Email each recipient in query results;
- Enter ticket subject (mine is: Ticket $ticknum Reopened);
- Enter OWNER_EMAIL for Column containing email addresses:
- Enter message (mine says: Closed ticket $ticknum owned by "$owner_name" has been reopened. You may review the ticket here: http://kbox/adminui/ticket$id=$ticknum. The status was "$$status_name" and is now marked as "Reopened".)

Select Run update query and enter in:

update HD_TICKET as T, HD_STATUS as STATUS 
set T.HD_STATUS_ID = STATUS.ID, 
T.RESOLUTION = CONCAT(T.RESOLUTION,'
Reopened'), 
T.TIME_OPENED  = IF(STATUS.STATE = 'opened', NOW(), T.TIME_OPENED), 
T.TIME_CLOSED  = IF(STATUS.STATE = 'closed', NOW(), T.TIME_CLOSED), 
T.TIME_STALLED = IF(STATUS.STATE = 'stalled', NOW(), T.TIME_STALLED), 
T.SATISFACTION_RATING = IF(STATUS.STATE = 'closed', NULL, T.SATISFACTION_RATING), 
T.SATISFACTION_COMMENT = IF(STATUS.STATE = 'closed', NULL, T.SATISFACTION_COMMENT) 
where STATUS.NAME = 'Reopened' and 
T.HD_QUEUE_ID = STATUS.HD_QUEUE_ID and  (T.ID in (<TICKET_IDS>))

-----

Set the schedule to run on Ticket Save.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ