We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

get the users list from an assignment group using an array

Not applicable

Hi,

I have created a catalog item with two variables assignment_group, and users. My requirement is to populate the users based on the assignment group. I want to use arrays to store the users list in an array. I want to know how it is done. Kindly help.

 

1.png

 

2.png

 

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

	getGroupMemberFun: function(){
		var assignGroup = current.variables.assignment_group;
		var userList = [];
		var grMember = new GlideRecord("sys_user_grmember");
		grMember.addQuery("group", assignGroup);
		while(grMember.next()){
			
		}

	},

    type: 'getMemberDynamicReferenceQualifier'
};

 

Regards

Suman P.

1 REPLY 1

VaishnaviShinde
Kilo Sage

Hello @Community Alums ,

 

Please add below script in script include

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

    getGroupMemberFun: function(assignGroup) {
        gs.info('In Si assignGroup:' + assignGroup);
        // var assignGroup = current.variables.assignment_group;
        var userList = [];
        var grMember = new GlideRecord("sys_user_grmember");
        grMember.addQuery("group", assignGroup);
		grMember.query();
		gs.info('In Si Count:'+grMember.getRowCount())
        while (grMember.next()) {
			// gs.info('In Si user:'+)
            userList.push(grMember.user.toString());
        }
        gs.info('In Si User Array:' + userList);
        return  'sys_idIN'+userList.join(',');
    },

    type: 'getMemberDynamicReferenceQualifier'
};

 

And add the below line in the User variable reference qualifier, use Advance Reference Qualifier

javascript: new global.getMemberDynamicReferenceQualifier().getGroupMemberFun(current.variables.group);

 

Please Mark my Solution as Accept VaishnaviShinde_0-1703918264872.png and Give me a thumbs up VaishnaviShinde_1-1703918264873.png, if you find it Helpful.

 

Regards,

Vaishnavi Shinde