How can I add a specific email address to the CC_LIST when a ticket is created?  I only know how to set that person to the CC_LIST which removes anyone else that was already in the list. 

Here is what my Update query looks like but this is just replacing the entire list.  I need to just add 'user@abc.com' to the existing list.

update HD_TICKET
    set HD_TICKET.CC_LIST = 'user@abc.com'
  where
        (HD_TICKET.ID in (<TICKET_IDS>))

Answer Summary:
Cancel
2 Comments   [ + ] Show Comments

Comments

  • totero21,

    Are you looking to have someone be added to the CC list of a ticket based upon the Category of ticket? If so that can be done in Queue Configuration.
  • No, it will be based on who the submitter is. This is for our HR portal and we have multiple locations. Depending on the submitter, we want our local IT people to be automatically CC'd in the tickets without the HR person having to add them each time.
Please log in to comment

Answer Chosen by the Author

1

Your UPDATE statement should look something like:

update HD_TICKET
set HD_TICKET.CC_LIST = CONCAT(HD_TICKET.CC_LIST,', user@abc.com')
where
(HD_TICKET.ID in (<TICKET_IDS>))

I can't recall off the top of my head what the CC_LIST field uses as a delimiter for multiple email addresses (space, comma, semicolon), but make sure to include that inside the quotes, too (I used comma in my example)

Answered 04/22/2016 by: BHC-Austin
Fourth Degree Black Belt

  • The delimiter is comma
  • Thanks, works great!
Please log in to comment

Answers

Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share