Dashboard hierarchy filter issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
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.