Reference qualifier for group variable to display only groups for the selected user

Ogrecic · ‎03-10-2021

Hi All!

I'm currently building a catalog item for a request to remove user from groups. There is firstly a user field from sys_user table and then groups field. What I'm trying to do is to link these 2 fields so when the user is selected, in the groups field would appear only the groups that this particular user is part of. Yet no success. Any ideas?

Thank you in advance.

Best regards,

Oleg.

Ankur Bawiskar · ‎03-10-2021

Hi,

You will have to create reference qualifier for the 2nd variable and call script include function

how to call script include in 2nd variable

javascript: 'sys_idIN' + new GetGroupMembers().getGroups(current.variables.userVariableName);

Script Include:

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

	getGroups:function(user) { 
		
		var group_array = [];
		var getMembers = new GlideRecord('sys_user_grmember');
		getMembers.addQuery('user ',user);
		getMembers.query();
		while(getMembers.next())
		{
			var groupSysId = getMembers.getValue('group');
			group_array.push(groupSysId);
		}
		return group_array;
	},

	type: 'GetGroupMembers'
};

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · ‎08-15-2021

what is not working?

did you add gs.info() to debug

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

RudhraKAM · ‎07-21-2023

This might be Old post but just adding other option, so that some one can use it ,

In the Reference variable , Select group member table and use the group sysID , this will fix the issue