Ok , got it, you can use this code. you might required some minor adjustments for input and output parameters.
created a new column on my PDI for this Nth level and used the calculated value to display Nth value based on current department.
updated the script code for this
you can copy exact code in calculated value, its generic as its taking the current record department for nth level
(function calculatedFieldValue(current) {
var deptArray = [];
getLastLevel(current.department);
function getLastLevel(dept){
var grDept = new GlideRecord("cmn_department");
grDept.addQuery("parent",dept);
grDept.query();
if(grDept.next()){
deptArray.push(grDept.sys_id);
getLastLevel(grDept.sys_id);
}
}
return deptArray[deptArray.length-1];
})(current);
result
Hi @Lak,
As per the details given, the department hierarchy flow from top to bottom and user Mike belong to ABC in sys_user table and ABC is parent of BCD , BCD parent of CDE, CDE parent of XYZ , if this is correct understanding then use below code to get Nth level down department value for any given user's department
Created department hierarchy
In my PID, user [ andrew.jackson] 's department = ABC, and below script will return the XYZ.
Note: This code will return the Nth ( down ) level department name for such hierarchy.
var deptArray = [];
var count =0;
var grUser = new GlideRecord("sys_user");
grUser.addQuery("user_name","andrew.jackson"); // replace the use name
grUser.query();
if(grUser.next()){
//call the function with user's departmert
getLastLevel(grUser.department);
//display the last level department name from array
gs.info("deptArray->"+deptArray[deptArray.length-1]);
}
function getLastLevel(dept){
var grDept = new GlideRecord("cmn_department");
// check if department is added as parent of any other department
grDept.addQuery("parent",dept);
grDept.query();
// if any other department found
if(grDept.next()){
// add the department name for given parent department
deptArray.push(grDept.name);
// check for next down level for department name
getLastLevel(grDept.sys_id);
}
}
Executed this code in fix-script for result
-Thanks,
AshishKMishra
