How to show only users from respective group in reference field (sys_user) table

Santhosh23 · ‎04-19-2021

Can anyone please explain me how to filter the users from only one group in reference fields reference to sys_user table.

Ankur Bawiskar · ‎04-19-2021

Hi,

you need to use advanced reference qualifier on that user reference field

javascript: 'sys_idIN' + new GetGroupMembers().getUsers();

Script include

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

	getUsers: function(){

		var arr = [];
		var gr = new GlideRecord("sys_user_grmember");
		gr.addQuery("group.name", "ABC Group");
		gr.query();
		while(gr.next()) {
			arr.push(gr.getValue('user'));
		}
		return arr.toString();

	},

	type: 'GetGroupMembers'
};

Regards
Ankur

View solution in original post

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