I'm looking for a notification, that is triggered when a review is created with unassigned items.
I've tried to setup a standard escalation workflow, but I couldn't configure it to email only when there are actual unassigned items.
I've tried to modify the escalation workflow i created, but I can't figure out how to proceed.
I implemented a decision node but can't specify a check for the number of unassigned items. In the email template this is ${UnReviewedItems}.
One way to achieve the functionality:
The URL for Monitor variable (${review_rvw_monitor_url}) contains a URL and the URL has the id of the review.
In the example below, the ID is 662
One you have this id, you can query V_AV_REVIEW_COMPONENTS.
IS_UNASSIGNED column will let you know if the item is unassigned (IS_UNASSIGNED='Y')
Use the following query to get the number of unassigned items for a review.
Once you have the value (in UNASSG variable), use a decision node to route the workflow to email node or to stop node.