Hello @Mimi Edet
You can use the following approach to continue with work left by the previous engineer.
1. Create an Event in Registry:
2. Create Scheduled Script Job: Try to adjust Time Zone and Time as per your need.
var incGr = new GlideRecord('incident');
//Add query for state in New, In progrees and OnHold and Assignment group is "Applciation Development", You can change sys_id of assignment group according to group sys_id in your insatnce.
incGr.addEncodedQuery("assignment_group=0a52d3dcd7011200f2d224837e6103f2^stateIN1,2,3");
incGr.setLimit(1);
incGr.query();
if(incGr._next()){
var group_manager = incGr.assignment_group.manager + "";
if(!gs.nil(group_manager)){
gs.eventQueue('custom.incident.active.weekly_report', incGr, group_manager, "");
}
}
3. Create Email Script: I have used ordered list for Incidents list, you can even use the table format as presented by @Amit Verma
(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */
email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */
event) {
var inc_list = "<ol>";
var instance_url = gs.getProperty('glide.servlet.uri') + '/';
var count = 0;
var incGr = new GlideRecord('incident');
//Add query for state in New, In progrees and OnHold and Assignment group is "Applciation Development", You can change sys_id of assignment group according to group sys_id in your insatnce.
incGr.addEncodedQuery("assignment_group=0a52d3dcd7011200f2d224837e6103f2^stateIN1,2,3");
incGr.query();
while (incGr._next()) {
count++; //Instead of the counter you can use GlideAggregate / getRowCount
inc_list = inc_list + "<li><a href='" + incGr.getLink(true) + "'>" + incGr.getValue('number') + "</a> - " + incGr.getValue('short_description') + "</li>";
}
inc_list = inc_list + "</ol>";
email.subject = "Weekly summary -" + new GlideDateTime().getDisplayValue() + " Application Development Incidents" ;
template.print("<p>This week your group has " + count + " active incidents. See below for the list of incidents.</p>");
template.print(inc_list);
})(current, template, email, email_action, event);
4. Create Notification:
When to Send:
Who will receive:
Content:
And here is the final output:
Please mark my answer helpful 👍 and accept as a solution ✔️ if it helped you.
Hi @Mimi Edet
You can do it with a Flow as well. Refer below steps -
1. Create a flow with trigger set to Weekly - Monday. Set the time to trigger as per your requirement :
2. Create a flow variable to hold the HTML string and set the initial HTML to form the table structure -
<html>
<head>
<style>
table {
font-family: arial, sans-serif;
border-collapse: collapse;
width: 100%;
}
td, th {
border: 1px solid #dddddd;
text-align: left;
padding: 8px;
}
tr:nth-child(even) {
background-color: #dddddd;
}
</style>
</head>
<body>
<h2>Open Incidents</h2>
<table>
<tr>
<th>Incident Number</th>
<th>Link to Incident</th>
</tr>
3. Get All the incidents assigned to you using Look Up records. Please change the Assigned To to your user -
4. Iterate through the assigned to incidents using for each item. Within the for each scope , we will set the flow variable again to append the table data html to our existing html string -
var html = fd_data.flow_var.openincidentshtml;
var instanceURL = gs.getProperty('glide.servlet.uri')';
var incidentLink = '<a href="' + instanceURL + 'incident.do?sys_id=' + fd_data._3__for_each.item.sys_id + '">' + fd_data._3__for_each.item.number + '</a>';
html+='<tr><td>'+fd_data._3__for_each.item.number+'</td><td>'+incidentLink+'</td></tr>';
return html;
5. Next, we will set the flow variable again outside the for each scope to terminate the HTML string -
var html = fd_data.flow_var.openincidentshtml;
html+='</table></body></html>';
return html;
6. Finally, we will make use of Send Email action. You can change the to email ID to your email ID.
Output -
Thanks and Regards
Amit Verma
Hello @Mimi Edet
You can use the following approach to continue with work left by the previous engineer.
1. Create an Event in Registry:
2. Create Scheduled Script Job: Try to adjust Time Zone and Time as per your need.
var incGr = new GlideRecord('incident');
//Add query for state in New, In progrees and OnHold and Assignment group is "Applciation Development", You can change sys_id of assignment group according to group sys_id in your insatnce.
incGr.addEncodedQuery("assignment_group=0a52d3dcd7011200f2d224837e6103f2^stateIN1,2,3");
incGr.setLimit(1);
incGr.query();
if(incGr._next()){
var group_manager = incGr.assignment_group.manager + "";
if(!gs.nil(group_manager)){
gs.eventQueue('custom.incident.active.weekly_report', incGr, group_manager, "");
}
}
3. Create Email Script: I have used ordered list for Incidents list, you can even use the table format as presented by @Amit Verma
(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */
email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */
event) {
var inc_list = "<ol>";
var instance_url = gs.getProperty('glide.servlet.uri') + '/';
var count = 0;
var incGr = new GlideRecord('incident');
//Add query for state in New, In progrees and OnHold and Assignment group is "Applciation Development", You can change sys_id of assignment group according to group sys_id in your insatnce.
incGr.addEncodedQuery("assignment_group=0a52d3dcd7011200f2d224837e6103f2^stateIN1,2,3");
incGr.query();
while (incGr._next()) {
count++; //Instead of the counter you can use GlideAggregate / getRowCount
inc_list = inc_list + "<li><a href='" + incGr.getLink(true) + "'>" + incGr.getValue('number') + "</a> - " + incGr.getValue('short_description') + "</li>";
}
inc_list = inc_list + "</ol>";
email.subject = "Weekly summary -" + new GlideDateTime().getDisplayValue() + " Application Development Incidents" ;
template.print("<p>This week your group has " + count + " active incidents. See below for the list of incidents.</p>");
template.print(inc_list);
})(current, template, email, email_action, event);
4. Create Notification:
When to Send:
Who will receive:
Content:
And here is the final output:
Please mark my answer helpful 👍 and accept as a solution ✔️ if it helped you.
