Hello @Samiksha2
A script include to carry out our all logic as needed:
var NotifyOpenTasks = Class.create();
NotifyOpenTasks.prototype = {
initialize: function() {},
checkAndNotify: function() {
var now = new GlideDateTime();
var ritmGr = new GlideRecord('sc_req_item');
ritmGr.addQuery('state', '!=', '3'); // Assuming '3' is the closed state
ritmGr.query();
while (ritmGr.next()) {
var terminationDateTime = ritmGr.variables.termination_date_time; // Replace with the actual variable name
if (terminationDateTime) {
var terminationDateTimeObj = new GlideDateTime(terminationDateTime);
terminationDateTimeObj.addHoursUTC(2);
if (now >= terminationDateTimeObj) {
this.notifyOpenTasks(ritmGr.sys_id);
}
}
}
},
notifyOpenTasks: function(ritmSysId) {
var gr = new GlideRecord('sc_task');
gr.addQuery('request_item', ritmSysId);
gr.addQuery('state', '!=', '3'); // Assuming '3' is the closed state
gr.query();
while (gr.next()) {
var groupId = gr.assignment_group;
var groupEmail = gr.assignment_group.email;
if (groupId && groupEmail) {
this.notifyGroupMembers(groupId, gr);
}
}
},
notifyGroupMembers: function(groupId, taskRecord) {
gs.eventQueue('task.open.notification', taskRecord, taskRecord.number);
}
},
type: 'NotifyOpenTasks'
};
A email notification on sc_task table only triggered when event is fired event name "task.open.notification" in that email you can put your own content as required and in who will receive select Assignment Group field.
This all above configuration will help you to send email to group who has not completed task if termination date/time is 2 hrs from current date/time.
If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.
Thanks & Regards
Viraj Hudlikar.
