Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

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

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

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

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:39
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.