How can I create a WHERE clause to send notification when an issue is in the unreviewed state in Issue Manager?
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
Once you add this rule just create an email trigger, assign it to this rule and make the user the recipient of the email.