How to retrieve all users in the caller field who belong to the same department as the logged in use

[vardhan3]

Hi All,

How to retrieve all users in the caller field who belong to the same department as the logged in user?

I have written below script include but it's doesn't fetch correct data

var DepatmentNameUtil = Class.create();

DepatmentNameUtil.prototype = {

    initialize: function() {},

    departmentName: function() {

        gs.info("department" + gs.getUserID());

        var user_dep = new GlideRecord("sys_user");

        user_dep.addQuery("sys_id", gs.getUserID());

        user_dep.query();

        if (user_dep.next()) {

            return "department" + " " + user_dep.department.toString();

        }

    },

    type: 'DepatmentNameUtil'

};

[Ankur Bawiskar · Accepted solution]

@vardhan3 

you can use something like this in advanced ref qualifier

no script include required

javascript: 'department=' + gs.getUser().getDepartmentID();

If my response helped please mark it correct and close the thread so that it benefits future readers.

[vardhan3]

Hi @Ankur Bawiskar 

The logic is working as expected, Cloud pls tell me why script include is nit working?

[Ankur Bawiskar]

@vardhan3 

you should update script as this and use array to hold user sysIds and then return the query

    departmentName: function() {
        gs.info("department" + gs.getUserID());
		var arr = [];
        var user_dep = new GlideRecord("sys_user");
        user_dep.addQuery("sys_id", gs.getUserID());
        user_dep.query();
        while (user_dep.next()) {
            arr.push(user_dep.getUniqueValue());
        }
		return 'sys_idIN' + arr.toString();

    },

ref qualifier as this in that field

javascript: new DepatmentNameUtil().getDepartmentName();

If my response helped please mark it correct and close the thread so that it benefits future readers.

[vardhan3]

Hi Ankur,

It's displaying only logged in user record, total 35 records are there in same dapartment