Hello @tulasi8 ,
Create an Email Notification, configure all the required details (table should be Incident obviously).
Put appropriate criteria like when to trigger , whom to send etc.
After that the most important part is to create Email Notification Script. Create the email notification script as shown below:
(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
var incGr = new GlideRecord('incident');
incGr.addEncodeduery('priority=1^state=2');
incGr.query();
var incList = [];
while(incGr.next()){
var obj = {};
obj.number = incGr.getValue('number');
obj.person = incGr.caller_id.getDisplayValue();
obj.shortDesc = incGr.getValue('short_description');
obj.state = incGr.state.getDisplayValue();
incList.push(obj);
}
var htmlData = "<table><tr><th>NUMBER</th><th>CALLER PERSON</th><th>STATE</th><th>SHORT DESC</th></tr>";
template.print(htmlData);
incList.forEach(function(eachData){
var currentRow = "<tr><td>"+eachData.number+"</td><td>"+eachData.person+"</td><td>"+eachData.state+"</td><td>"+eachData.shortDesc+"</td></tr>";
template.print(currentRow);
});
template.print("</table>");
})(current, template, email, email_action, event);
After that call the email script in your email notification as shown below:
Now click on preview button to see the result:
As you can see the table list of all the incidents. You can do styling and filter condition to get those 25 incidents in your email script criteria.
All of this really takes time to put to help you understand kindly mark this solution as helpful.
Thank you,
Mahesh.
