I'm trying to write a SQL Select statement for a new Email Notification rule which will send an auto-email to the current user -- ie. the user that modified the ticket.
Although it's true I could create a new field which would be updated every time a record is updated and email to the email address in that field, I'd rather not add to the overhead.
I'm having trouble figuring this out. Or even if it's possible. I do have select statements in place for other email rules which will send out an email to people in a particular email group. An example would look like this:
FROM parent_child_links T1, groups T3, users T2
WHERE T1.parent_dbid = T2.dbid
AND T1.child_dbid = T3.dbid
AND T3.name = '<usergroupname>'")
Any help would be appreciated.