Small change in job; we need to use the uniqueArray for length
Also we need to send the assigned_to user so that it will help in our email script query
Job script change:
sendEmail();
function sendEmail() {
var arr = [];
var gr = new GlideRecord('incident');
gr.addEncodedQuery('active=true^assigned_toISNOTEMPTY');
gr.query();
while (gr.next()) {
arr.push(gr.assigned_to.toString());
}
var arrayUtil = new ArrayUtil();
var uniqueArray = arrayUtil.unique(arr);
var inc = new GlideRecord('incident');
inc.addQuery('assigned_to', 'IN', uniqueArray);
inc.setLimit(uniqueArray.length);
inc.query();
while (inc.next()) {
gs.eventQueue('test_list', inc, gs.getUserID(), inc.assigned_to);
}
}
Small change in email script:
template.print("<table width=70% border=1><tr bgcolor=#e2e0de><td>Number</td><td>Priority</td><td>Caller ID</td><td>Short Desc</td></tr>");
var inc = new GlideRecord('incident');
inc.addQuery('active', true);
inc.addQuery('assigned_to', event.parm2);
//inc.addQuery('state','5');
inc.query();
while (inc.next()) {
template.print("<tr><td>" + inc.number + "</td><td>" + inc.priority + "</td><td>" + inc.caller_id.getDisplayValue() + "</td><td>" + inc.short_description + "</td></tr>");
}
template.print('</table>');
It worked as below:
Total Incidents with Active=true && Assigned to Not EMPTY = 27
Unique Assigned To users = 9
So email triggered 9 times
Preview of Email:
Regards
Ankur
