Creating Alert for Cancelling Scheduled Training Learning Are Enrolled In

Summary

Creating Alert for Cancelling Scheduled Training Learning Are Enrolled In

Content

Hello, I'm trying to create an alert for a cancelled activity that's scheduled in Learning. 

To cancel, I'm following:

Step 1: Put a publish end date to learning item

Step 2: Select all the enrolled learners who are In Progress or Not started status and choose action as 'Withdraw'

 

Here is the current alert I have setup, but it's not triggering any notifications.

LearnerLearningRecord

${assignmentStatus} = 'ORA_ASSN_REC_DELETED'

${reasonCode} = 'ORA_SEPC_DEL'

exists (SELECT 'x' from dual  where ${assignmentLastModifiedDate} >= (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 = 'A5798C6457F46637E053847F230A407B'))