@SnowDevOps
I think, To send notifications to students enrolled in each course two days before the class starts, you'll need to design a process that iterates through each course record, checks its start date, retrieves enrolled students, and sends notifications to them...means Set up a scheduled job that runs daily to check for courses starting within two days and trigger an event to send notification..below is the sample code
// Query courses starting within two days
var coursesGr = new GlideRecord('courses');
coursesGr.addQuery('start_date', '>=', gs.daysAgo(2)); // Courses starting within two days
coursesGr.addQuery('start_date', '<=', gs.daysAgo(1)); // Courses starting after two days
coursesGr.query();
while (coursesGr.next()) {
var courseName = coursesGr.getValue('name');
var teacher = coursesGr.getValue('teacher');
// Query enrollment for this course
var enrollmentGr = new GlideRecord('enrollment');
enrollmentGr.addQuery('course', coursesGr.getUniqueValue()); // Link to the course
enrollmentGr.query();
while (enrollmentGr.next()) {
var studentName = enrollmentGr.getValue('student');
var email = enrollmentGr.getValue('student_email');
// Queue the event to send notification to student
gs.eventQueue('notification.student.reminder', null, email); // modify as per your event
}
}
Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.
Thanks
