Need to populate the bottom most department of a user

[Lak]

For any given user(Mike), We would need to show the bottom most department(XYZ).

Note: User could be associated to any department in the hierarchy, any help or suggestions

User: Mike

Department:

                      --ABC

                         --BCD

                             --CDE

                                 --XYZ

[Lak]

Hi @AshishKM ,

The challenge with calculated field is that I don't have an i icon to refer the details of that filed and which will be available only through reference field hence I have tried calling the script include through qualifier reference qualifier but unfortunately it isn't working.

Regards,

Lakshmi

[AshishKM]

@Lak , let me know if you can share the screen and we are review the code. 

[Lak]

Hi @AshishKM , Thanks for the logic provided here, I was able to manage and built the same into my existing script include function and I am able to transform the data and was able to get the nth level department. Thanks again Ashish for the support you have enabled.

regards,

Lakshmi 

[AshishKM]

@Lak,thanks for replying and confirming, Please accept solution and close this thread for others.

[Amit Gujarathi]

HI @Lak ,
I trust you are doing great.

Here's a template to modify the script for integration:

// Script Include Template
var BottomMostDepartment = Class.create();
BottomMostDepartment.prototype = {
    initialize: function() {
    },

    getBottomMostDepartment: function(userId) {
        var deptArray = [];
        var grUser = new GlideRecord("sys_user");
        grUser.addQuery("user_name", userId); // Replace with actual user field
        grUser.query();
        if(grUser.next()){
            this.getLastLevel(grUser.department, deptArray);
            return deptArray[deptArray.length - 1];
        }
        return ''; // Return empty if no department found
    },

    getLastLevel: function(dept, deptArray) {
        var grDept = new GlideRecord("cmn_department");
        grDept.addQuery("parent", dept);
        grDept.query();
        if(grDept.next()){
            deptArray.push(grDept.name);
            this.getLastLevel(grDept.sys_id, deptArray);
        }
    },

    type: 'BottomMostDepartment'
};