Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Alerts Composer: Reminder for Learners when an activity (offering) starts in the next 7 days
Content
Hello all,
we have the requirement to create a custom alert via Alerts Composer when an activity of an offering the Learner is enrolled to, is going to start in the next seven days:
We are struggeling with the filter criterias:
We used:
Resource: learnerLearningRecords/selectedCourseOfferings/completionDetails
trunc(${activityDate}) BETWEEN trunc(sysdate) AND trunc(sysdate+7)
${activityStartTime} IS NOT NULL
${activityStartTime} BETWEEN '00:00' AND '24:00'
but it doesn't work.
In result we still receive mails like the attached one (Image 1) with "null" as the start time.
Otherwise we also get good mails (please see image 2)
The system seems not to take the activity date.
2