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   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



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:

'helpdesk@mycompany.com' 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