Need to Display SLA due(Duration field) in email notification, I am using notification scrip
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2023 11:12 AM
PFA below notification script, which I am using.
(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */
email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */
event) {
// Add your code here
var gr = new GlideRecord('task_sla');
gr.addQuery('sla', '4a9c3e2c87a751900303f659dabb359c');
gr.addQuery('task', current.sys_id);
gr.query();
if (gr.next()) {
var businessTimeLeft = gr.business_time_left.getDisplayValue();
var daysInSeconds = 86400; // 1 day = 86400 seconds
var hoursInSeconds = 3600; // 1 hour = 3600 seconds
var minutesInSeconds = 60; // 1 minute = 60 seconds
var days = (businessTimeLeft / daysInSeconds) | 0;
businessTimeLeft -= days * daysInSeconds;
var hours = (businessTimeLeft / hoursInSeconds) | 0;
businessTimeLeft -= hours * hoursInSeconds;
var minutes = (businessTimeLeft / minutesInSeconds) | 0;
var seconds = businessTimeLeft % minutesInSeconds;
var durationValue = "Days " + days + " Hours " + hours + " Minutes " + minutes + " Seconds " + seconds;
template.print(durationValue);
}
})(current, template, email, email_action, event);
0 REPLIES 0