Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Alerts Composer - expression to remove employees based upon email suffix
Tools > Alerts Composer
Selecting an enabled ‘Resource Alert’ that contains template content and run option of daily. Has been running without issue for a number of months, and performs requirement of sending email out to new employees.
Question: is it possible to add/amend expression to cease sending to select employees, when a specific email suffix is used
e.g. do not send to any employee with the email suffix @yellowlorry.com
Existing filter looks as follows:
Resource = learnerLearningRecords
Two expressions:
‘Created in Last Day’ expression =
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 = '9970E01283FB2AD7E0530790CA0AFD66'))