Hi
Yes we can iterate through the child departments so that we can roll up every level. Amend the above script include (Client Callable TRUE) as below:
var getChildDepartment = Class.create();
getChildDepartment.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getChildDepartmentMethod: function(parentDept){
var arr = [parentDept];
var deptArr = this.getAllDepartments(parentDept, arr);
return deptArr;
},
getAllDepartments : function(parentDept, returnArr){
var dept = new GlideRecord('cmn_department');
dept.addEncodedQuery('parent='+parentDept);
dept.query();
while(dept.next()){
returnArr.push(dept.sys_id.toString());
this.getAllDepartments(dept.sys_id.toString(), returnArr);
}
return returnArr;
},
type: 'getChildDepartment'
});
The query on the report changes as below where I have input the 'sys_id' of the department. Since we could be dealing with 'n' number of departments as we roll down the parent-child hierarchy, its best we input the 'sys_id' of the department.
So your query will be 'Caller.Department.SysID' 'is one of' 'javascript: (new getChildDepartment()).getChildDepartmentMethod('sysIDofDepartment')'
I have created a hierarchy as below:-
And my report where I input the sys_id of "Department 1" (which is grouped by caller.department) looks like below:-
Hope it helps! 🙂
Kindly mark my comment as correct/helpful based on the impact. Thank You!
