Dashboard hierarchy filter issue

Abishek1998
Tera Contributor

Hi, 

 

I am working on a use case where I want to show the assignment groups of a manager and that managers hierarchy assignment groups also. If I am the manager and i am the manager of 4 assignment groups and The user1 is also a manager but his manager is me, then I want his assignment groups also.  I have created a filter and created a script include. 

Below Code:

var DashboardManagerGroups = Class.create();
DashboardManagerGroups.prototype = Object.extendsObject(AbstractAjaxProcessor, {

// Filter 1: Manager field - Returns ALL managers of ITIL groups
getAllManagers: function() {

var finArr = [];

var grp = new GlideRecord('sys_user_group');
grp.addQuery('active', true);
grp.addNotNullQuery('manager');
//grp.addQuery('type', '1cb8ab9bff500200158bffffffffff62');
grp.addEncodedQuery('managerIN_HIERARCHY1667a6feeb4112101e31e5b26b52283f@08f2dabc1b2ce21093402fc3b24bcb37@0@true');
grp.query();

while (grp.next()) {
var mgrId = grp.getValue('manager');
if (finArr.indexOf(mgrId) === -1) {
finArr.push(mgrId);
}
}

gs.info("ITIL Managers Result: " + finArr);
return finArr;
},

// Filter 2: Assignment Group - Returns ITIL groups sys_ids
getAllManagerGroups: function() {

var finArr = [];

var grp = new GlideRecord('sys_user_group');
grp.addQuery('active', true);
grp.addNotNullQuery('manager');
//grp.addQuery('type', '1cb8ab9bff500200158bffffffffff62');
grp.query();

while (grp.next()) {
finArr.push(grp.getValue('sys_id'));
}

gs.info("ITIL Groups Result: " + finArr);
return finArr;
},

type: 'DashboardManagerGroups'
});

But I can't get the hierarchy.

0 REPLIES 0