How to send an email to an arbitrary email address via a ticket rule
It's actualy pretty frustrating that you can't just type in an email address to send to in a rule. e.g: Why on earth would anyone ever want to get an email-based help system to send an email to an arbirary email address? But I digress. I read this post (below) on how to send an email via a ticket rule, but the last post on this thread is not complete.
All I'm trying to do is get the KBOX to send an email to a person or group of people when a new ticket is received. To start with I created a rule that looked for all tickets with STATUS = "New" and set it to run when the ticket is saved.
The post above says you have to hardcode the email address you want to send to in the select statement like this:
select ID, 'email@example.com' SUPPORT from HD_TICKET WHERE 1=1
That's all find and good, but not being a SQL expert, how do I do that when I already have a select statement (du)? Where do I put this?
Much Thanks in advance.