You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Alerts Composer - expression to remove employees based upon email suffix

Accepted answer
13
Views
2
Comments

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'))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!