Alert for Completed with the EXIST clause

Jun 28, 2021 1:22PM

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?

Alert for Completed with the EXIST clause

Content

Howdy, Stranger!