fetch the list of users who are under my manager

[Community Alums]

This is a code written in one the script include which I am using in one of the variable in advance reference qualifier.  I am not getting the expected result. I am getting "no matches found in the drop down". Please help me to modify the code if I am doing something wrong here.

var managername ='';
                       var loggedInUserManager ='';
                    var a = new GlideRecord('sys_user');
                        //if (a.get(gs.getUserID()))
                            // managername =a.manager.name;
                    //managername = userID.getValue('manager');
                    //var loggedInUserManager ='';
                //loggedInUserManager = gs.getUser(). getRecord(). getValue('manager');
                    a.addQuery('manager',gs.getUser().getManagerID());
                    a.addEncodedQuery('active=true^u_worker_type=Contingent Worker');
                    a.query();
                   var users = '';
                    while (a.next()) {
            users = users + "," + a.sys_id;
        }
        return 'sys_idIN' + users;

[Sagar Pagar]

Hi,

Replace your line

a.addQuery('manager',gs.getUser().getManagerID());

with

a.addQuery('manager',gs.getUserID());

Thanks,
Sagar Pagar

[Aman Kumar S]

Hi @Robin Kumar ,

Update your code as below:, just copy and paste, it would work

var managername ='';
var loggedInUserManager ='';
var a = new GlideRecord('sys_user');
a.addQuery('manager',gs.getUser().getRecord().getValue('manager'));
a.addEncodedQuery('active=true^u_worker_type=Contingent Worker');
a.query();
var users = [];
while (a.next()) {
  users.push(a.getUniqueValue());
}
return 'sys_idIN' + users.toString();

Feel free to mark correct, if your issue has been resolved, so it ends up in solved queue.

Will be helpful for others looking for the similar query.

[Aman Kumar S]

Hi @Robin Kumar 

Is your issue resolved?

Feel free to mark correct, if your issue has been resolved, so it ends up in solved queue.

Will be helpful for others looking for the similar query.

[Community Alums]

Hi Aman,

It is not working as expected, but one thing I observed is if write like below code then it shows correct list of user in the drop down. But if we add dynamically the logged in user manager in line 2 as you suggested is not working. 

var a = new GlideRecord('sys_user');
                    //a.addQuery('manager', gs.getUser().getRecord().getValue('manager'));
                    a.addEncodedQuery('manager=f3c3dfeadbbf870092127b5b8c9619c5');
                    a.query();
                    var users = [];
                    while (a.next()) {
                        users.push(a.getUniqueValue());
                    }
                    return 'sys_idIN' + users.toString();