Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Alert for Completed with the EXIST clause
Content
Hi there
We use the EXIST clause for enrollment notifications
exists (SELECT 'x' from dual where ${assignmentCreatedDate} >= (select nvl(max(runs.run_end),sysdate-1) from hrc_alert_runs runs, hrc_alerts_b alerts where runs.alert_id = alerts.alert_id and alerts.alert_code = 'C2E88D2D4DFED79BE0530860750AD2C2'))
I combine it with the statuses
${assignmentStatus} <> 'ORA_ASSN_REC_WITHDRAWN' AND ${assignmentSubStatus} <> 'ORA_ASSN_REC_WITHDRAWN' AND ${assignmentStatus} <> 'ORA_ASSN_REC_COMPLETE' AND ${assignmentSubStatus} <> 'ORA_ASSN_REC_COMPLETE' AND ${assignmentStatus} <> 'ORA_ASSN_REC_BYPASSCOMPLETE' AND ${assignmentStatus} <> 'ORA_ASSN_REC_DELETED'
it works well.
I wonder if one can use the EXIST clause for a Completed message? if yes, i guess one should not use the " ${assignmentCreatedDate}" but completedDate?