I want to setup an email notification rule to send me an email every time a defect enters my inbox therefore what SQL code should I use?

0 Likes

Problem:

I want to setup an email notification rule to send me an email every time a defect enters my inbox therefore what SQL code should I use?

Resolution:

ANSWER
----------------------------------
The following rule will be evaluated when a defect enters a specific person"s inbox. In this example we will use a QA Engineer"s Inbox - "Bill - QA". Once a new issue reaches Bill"s inbox he will receive an email. If Bill sends the BUG to "Jim - Developer" to fix it Bill will not receive any email until Jim sends it back to Bill"s inbox for him to verify the fix.

DH.AssignedIn <> "Bill - QA" and DH.AssignedOut = "Bill - QA"


Once you create the rule you just need to set up an email trigger, assign it to this rule and specify Bill as the recipient of the email.

Old KB# 23717
Comment List
Anonymous
Related Discussions
Recommended