Ticket Rule: Send an email notification to the person when he or she is added to the CC list after the ticket has been created

Is there a way to send a notification to the people who have been added to the CC List after the ticket had been created with ticket rule? Ticket owner may want to include more people in the CC List after review the ticket. 

Thank you.

2 Comments   [ + ] Show comments
  • Do you specifically want to send them a notification that they have been added to the cc list? - chucksteel 1 year ago
  • Yes. When a submitter opens a ticket and have CC people, those CC people will receive a notification about the new ticket. I would like to send a notification to people who are later added to the CC list after the ticket was created. Therefore, I need to be able to tell who are the people added later and send them a notification about they have been added to the ticket CC list. - pamzhao 1 year ago

Answers (1)

Answer Summary:
Posted by: chucksteel 1 year ago
Red Belt

Top Answer

Creating a ticket rule that sends an email when the CC_LIST is definitely possible. The change is recorded in the HD_TICKET_CHANGE_FIELD table:


The problem I see is sending that notification only to those email addresses that were added. This query illustrates the challenge:

replace(AFTER_VALUE, BEFORE_VALUE, '') as 'New CC' 
and AFTER_VALUE like concat('%', BEFORE_VALUE, '%')

This is the simplest way I could think of to remove the values in the list before the change from the list after the change. Unfortunately, it doesn't work very well. For example, someone entered a typo in the CC list, emai, and then correct that to email@domain.com. The query result for this change is l@domain.com, which obviously isn't correct.

I would recommend sending the notification to all members in the CC list and wording the message something like "you are receiving this message because the CC list of ticket xxxx has been updated." This makes all of those aware that others are being included in ticket updates in the future.

  • This is very helpful.
    Thank you! - pamzhao 1 year ago
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