What's new in Customer Journeys?

Connect and learn more!
[ALERT COMPOSER WLF] - Filters for recently deleted assignments notification do not work correctly — Cloud Customer Connect
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

[ALERT COMPOSER WLF] - Filters for recently deleted assignments notification do not work correctly

Accepted answer
35
Views
2
Comments

Summary:

When I run my notifications for recently deleted assignments (learning records), I get no data.

Content (please ensure you mask any confidential information):

I'm working on standard notification learning ( Recently Withdrawn Assignments, Alert Code: WLF-00011). The basic standard notification filter expression is this:


exists (SELECT 'x' from dual where ${withdrawnDate} >= (select nvl(max(trunc(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 = 'WLF-00011'))


This is a notification to inform the employee that he has been withdrawn from a training in the last 24 hours. I'd like to modify the notification so that it also takes into account people who have been deleted from a training in the last 24 hours. I've modified the filters to do this, but it doesn't work:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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