Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

get the users list from an assignment group using an array

Community Alums
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