Ticket Rule - Can I send to an email address not returned by the query
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)?
Thanks
Answers (1)
You need to modify the SQL select statement to have it return the email address. This KB article outlines the procedures:
http://www.kace.com/support/resources/kb/article/How-To-Notify-Any-User-or-Group-by-Email-When-a-New-Help-Desk
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.
Comments:
-
Thank you Sir. I knew I had come across that line before but couldn't remember it for the life of me.
Thanks again
John - jmarotto 11 years ago
