How can I create a WHERE clause to send notification when an issue is in the unreviewed state in Issue Manager?

0 Likes

Problem:

How can I create a WHERE clause to send notification when an issue is in the unreviewed state in Issue Manager?

Resolution:

The following SQL rule sends an email to a recipient, when an issue is in the status of unreviewed. This works whether the issue is unreviewed because it has just been created or whether someone manually sets the state to unreviewed.

DH.StatusOUT= "Unreviewed" AND (DH.StatusIN <> DH.StatusOUT OR DH.ActionCode ="ENTERED")

Once you add this rule just create an email trigger, assign it to this rule and make the user the recipient of the email.


Old KB# 23836
Comment List
Anonymous
Related Discussions
Recommended