Show all the groups that the Requested For belongs to

[maineeeeeeeee]

Hello everyone,

I'm new to servicenow and I need help getting/showing all the groups that the Requested For (user) belongs to.

Could someone kindly assist me with a Script Include and advanced reference qualifier?

I would really appreciate it, thank you in advance

[Sandeep Rajput · Accepted solution]

@maineeeeeeeee Here is the script include for you.

var GetUserGroups = Class.create();
GetUserGroups.prototype = {
    initialize: function () {},

    getGroups: function (userId) {
        var groups = [];
        if (!userId) {
            return groups; // Return empty array if no user ID is provided
        }

        var gr = new GlideRecord('sys_user_grmember');
        gr.addQuery('user', userId);
        gr.query();
        while (gr.next()) {
            groups.push(gr.group.toString());
        }

        return "sys_idIN"+groups.toString();
    },

    type: 'GetUserGroups'
};

Here is how you should specify this reference qualifier.

javascript:new GetUserGroups().getGroups(current.variables.requested_for);

[Sandeep Rajput · Accepted solution]

@maineeeeeeeee Here is the script include for you.

var GetUserGroups = Class.create();
GetUserGroups.prototype = {
    initialize: function () {},

    getGroups: function (userId) {
        var groups = [];
        if (!userId) {
            return groups; // Return empty array if no user ID is provided
        }

        var gr = new GlideRecord('sys_user_grmember');
        gr.addQuery('user', userId);
        gr.query();
        while (gr.next()) {
            groups.push(gr.group.toString());
        }

        return "sys_idIN"+groups.toString();
    },

    type: 'GetUserGroups'
};

Here is how you should specify this reference qualifier.

javascript:new GetUserGroups().getGroups(current.variables.requested_for);

[maineeeeeeeee]

Hello @Sandeep Rajput , 
I tried doing this, but it still displays all the groups instead of only the ones the user belongs to.

[maineeeeeeeee]

Hello @Sandeep Rajput,
I tried doing your code, but it still displays all the groups instead of only the ones the user belongs to.

here's a screenshot. Thank you once again

[Sandeep Rajput · Accepted solution]

@maineeeeeeeee Here is how the reference qualifier should be called.