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