Working on a ticket rule that sends an email to a specific person. When selecting 'Send an email for each result row' can I just put the email address in the 'Email Column:' field?

If not, how do I incorporate the email address I wish to send to into the query when it doesn't belong to one of the usual participants (owner, submitter, approver, updater so on)?



Answer Summary:
0 Comments   [ + ] Show Comments


Please log in to comment



You need to modify the SQL select statement to have it return the email address. This KB article outlines the procedures: 

Basically you need to add a line like this to the select statement:

'' AS NEWTICKETEMAIL -- $newticketemail

You then use NEWTICKETEMAIL as the email column.

Answered 06/20/2013 by: chucksteel
Red Belt

  • Thank you Sir. I knew I had come across that line before but couldn't remember it for the life of me.

    Thanks again
  • This content is currently hidden from public view.
    Reason: Member has been banned from the site
    For more information, visit our FAQ's.
Please log in to comment
Answer this question or Comment on this question for clarity