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
https://192.168.1.1/aveksa/main?Oid=662&ReqType=Dialog&ObjectClass=com.aveksa.gui.objects.review.GuiReviewReport
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.
select count (*) as UNASSG
from V_AV_REVIEW_COMPONENTS
where IS_UNASSIGNED = 'Y'
and REVIEW_ID=(select substr('${review_rvw_monitor_url}',instr('${review_rvw_monitor_url}', 'Oid=', 1)+4, instr('${review_rvw_monitor_url}', '&')-instr('${review_rvw_monitor_url}', 'Oid=', 1)-4)from dual)
Once you have the value (in UNASSG variable), use a decision node to route the workflow to email node or to stop node.
Although this works, I think it should be a standard escalation workflow.
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.