notification mail scripts for additional comment
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2024 03:34 AM
Unable to create mail script for additonal comments please help me,
this is the code that i'm trying
(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
// Get the additional comments
var comments = current.comments;
// Get the record number and short description
var number = current.number;
var short_description = current.short_description;
// Build the email body
var body = "There are additional comments on record " + number + ": " + short_description + "\n\n";
body += comments;
// Set email subject and recipient (replace with your details)
var subject = "Additional Comments on Record " + number;
var recipient = current.caller_id.email;
// Send the email
email.setSubject("New Comment added to Incident: " + incident.number);
email.setBody("A new comment has been added to Incident " + incident.number + ": " + current.comments);
email.addRecipient(current.caller_id.email);
email.send();
})(current, previous);
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2024 11:04 AM
Hi VanajaD,
The comments are not stored with the object. They are in sys_journal_field. To retrieve the most recent comment, I set up a function in a script include so that I can use it wherever needed. Here's the function:
getMostRecentComment: function(commentID) {
var theComments = new GlideRecord("sys_journal_field");
theComments.addEncodedQuery("element_id=" + commentID.toString() + "^element=comments");
theComments.orderByDesc("sys_created_on");
theComments.setLimit(1);
theComments.query();
if (theComments.next()) {
return theComments.value;
} else {
return "---nuttin---";
}
},
You pass the sys_id of the object in question as the argument. I always use something like "---nuttin---" so that I have a positive way of knowing that the function ran but didn't find anything.
Hope that helps.
:{)
Helpful and Correct tags are appreciated and help others to find information faster
:{)
Helpful and Correct tags are appreciated and help others to find information faster