Hi All,
I have a requirement to Cancel the case if case is assigned to a assignment group= xyz and short description= 'Hire Set by HR Rep higher job group'
but there is a mandatory field called Assigned To, for which i want to assign the case to xyz group member having less number of tickets,
for this i have written a Before BR, please correct me where i am doing mistake
(function executeRule(current, previous /*null when async*/) {
var members = [];
var gm = new GlideRecord('sys_user_grmember');
gm.addQuery('user.active', true);
gm.addQuery('group', '4b88b9631bdaa05068e955b61a4bcba8');
gm.query();
while (gm.next()) {
members.push(String(gm.user));
}
// Get a list of their open ticket counts
var counts = [], agg, count;
for (var i = 0; i < members.length; i++) {
count = 0;
agg = new GlideAggregate('sn_hr_core_case');
agg.addEncodedQuer('active=true^assigned_to!=NULL');
agg.addQuery('assignment_group', '4b88b9631bdaa05068e955b61a4bcba8');
agg.addQuery('assigned_to', members[i]);
agg.addAggregate('COUNT');
agg.query();
if (agg.next())
count = agg.getAggregate('COUNT');
counts.push(count);
}
// find the minimum count and store its index
var min = counts[0];
var index = 0;
for (var j = 1; j < counts.length; j++) {
if (counts[j] < min) {
min = parseInt(counts[j]);
index = parseInt(j);
}
}
// get the member with the lowest count
var userID = members[index];
var h;
// Log their name to verify
var user = new GlideRecord('sys_user');
if (user.get(userID)) {
gs.log('Name: ' + user.sys_id);
h = user.sys_id;
}
current.assigned_to = h;
current.state= 7;
current.u_resolution_category_tier_1='BPO Team';
current.u_resolution_category_2= 'Request Cancelled';
current.u_resolution_category_3= 'No Activities Performed';
current.u_resolution_notes="No action needed at BPO's end, Hence cancelling this ticket.";
current.update();
})(current, previous);
