Custom notification Reminder - Required courses Self-Paced Offering

Summary:

Custom notification Reminder - Required courses Self-Paced Offering

Content (please ensure you mask any confidential information):

Hi all,

we are configuring custom notifications for a client using the filters. We need to trigger a reminder based on the due date of a required assignment for a Self- Placed Offer but it doesn't work.

Below the steps we made:

1) We have configured the notification using the below filters:

•  TRUNC(${assignmentDueDate}) >= ${AlertFilterUtils.addDays(AlertFilterUtils.getCurrentDate(),+1)}
• ${assignmentStatus} = 'ORA_ASSN_REC_ACTIVE'
• ${assignmentType} = 'ORA_REQUIRE_ASSIGNMENT'
• ${learningItemType} = 'ORA_SP'

Option selected: Match All

(P.S. We also have tried to use ${assignmentDueDate} <= sysdate+1 instead of CurrentDate but the result was the same)