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

Need Help on pending worker filter expression for an alert composer

in Human Capital Management

Summary:

Need Help on pending worker filter expression for an alert composer

Content (please ensure you mask any confidential information):

we have a requirement to send an alert to pending worker before 7days of his start date with details of start date, location and the manager name.

we have filter but it seems not working retrurning null currently using this filter expression: EXISTS (SELECT 'x' FROM PER_PERIODS_OF_SERVICE ppos WHERE ppos.person_id = ${PersonId} AND ppos.date_start >= ${AlertFilterUtils.addDays(AlertFilterUtils.getCurrentDate(), 7)} AND ppos.date_start < ${AlertFilterUtils.addDays(AlertFilterUtils.getCurrentDate(), 8)} AND ppos.actual_termination_date IS NULL) selected resource s "workers"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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