In requested for variables I need users of manger(manger is current login user)

[Siva82]

Hi Team,

I have a variable that needs to reference data from the user table.

In this case, I need to implement a reference qualifier. If the currently logged-in user is a manager, the variable should populate with the users managed by that person. Additionally, the variable should include the users managed by the logged-in manager's direct reports (ex:manger(3users)>> manger of manger(4users) = 7 Usrs need to populate)

For example:

• If a manager (X) has 3 direct reports, the variable should return 3 users.
• If another manager (Y) has 3 direct reports, and one of those users has a manager (Z) who oversees 4 users, the variable should return a total of 7 users (3 users from Y + 4 users from Z).

Thank you in advance

Sivananda reddy

[Ankur Bawiskar]

@Siva82 

you should have advanced ref qualifier on that variable and bring in the users

what script did you start with?

[Siva82]

Hi @Ankur Bawiskar 

Thank you for your response,

I have user below scrpit inulde and advanced ref qualifier, But no luck

Script inculde

var UserFilterForCatalogItem = Class.create();

UserFilterForCatalogItem.prototype = {

    initialize: function() {},

    getFilteredUsers: function() {

        var currentUserId = gs.getUserID(); // Get the currently logged-in user

        var userGr = new GlideRecord('sys_user');

        // userGr.addActiveQuery(); // Only active users

        userGr.addQuery('manager', currentUserId); // Users whose manager is the current user

        var users = [];

        userGr.query();

        while (userGr.next()) {

// users.push(userGr.name.toString());

                var userman = new GlideRecord('sys_user');

                userman.addQuery('manager', users);

users.push(userman.name.toString()+userGr.name.toString());

        }

        return users.join(',');

    },

    type: 'UserFilterForCatalogItem'

};

advanced ref qualifier

javascript: 'sys_idIN' + UserFilterForCatalogItem.getFilteredUsers();

Thank you

Siva

[Siva82]

Hi @Uncle Rob 

Thank you for your response,

I have user below scrpit inulde and advanced ref qualifier, But no luck

Script inculde

var UserFilterForCatalogItem = Class.create();

UserFilterForCatalogItem.prototype = {

    initialize: function() {},

    getFilteredUsers: function() {

        var currentUserId = gs.getUserID(); // Get the currently logged-in user

        var userGr = new GlideRecord('sys_user');

        // userGr.addActiveQuery(); // Only active users

        userGr.addQuery('manager', currentUserId); // Users whose manager is the current user

        var users = [];

        userGr.query();

        while (userGr.next()) {

// users.push(userGr.name.toString());

                var userman = new GlideRecord('sys_user');

                userman.addQuery('manager', users);

users.push(userman.name.toString()+userGr.name.toString());

        }

        return users.join(',');

    },

    type: 'UserFilterForCatalogItem'

};

advanced ref qualifier

javascript: 'sys_idIN' + UserFilterForCatalogItem.getFilteredUsers();

Thank you

Siva

[Ankur Bawiskar]

@Siva82 

check the script I shared below

[Uncle Rob]

Oh, ok... I get it now.  You want a reference qualifier to select only those users.
So when troubleshooting scripts its important that you do at least some logging.
Have you verified that the script is firing AT ALL?
Have you verified the value of the string field at any point in the first or second loops?

I'd start there.