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
="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.
Support
Documentation
Learning Services
Partner Programs