How to get the users who are members of a particular group?

ArpitaVK · ‎03-08-2024

I have a customized reference field in UI page 'review_request' for Exception request. It refers to the sys_user table.

<g:ui_reference name="service_desk" completer="AJAXTableCompleter" query="QUERY:active=true

^roles=ITIL" id="service_desk" table="sys_user" columns="user_name;first_name;last_name" />

In the above code, I want to add a condition that filters out the users which are members of 'Service desk' group. How can I query sys_user table in above code to filter the members of Service Desk group?

James Chun · ‎03-08-2024

Hey @ArpitaVK,

Try the following code:

<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
	<g:evaluate var="jvar_grMembers">
		var grMember = new GlideRecord('sys_user_grmember');
		grMember.addQuery('group', 'c38f00f4530360100999ddeeff7b1298'); //replace with your group
		grMember.query();
		var memberList = [];
		while (grMember.next()) {
		memberList.push(grMember.getValue('user'));
		}
		var memberStr = memberList.join(',');
		memberStr;
	</g:evaluate>

	<g:ui_reference name="service_desk" completer="AJAXTableCompleter" query="sys_idIN${jvar_grMembers}"
		id="service_desk" table="sys_user" columns="user_name;first_name;last_name" />
</j:jelly>

Cheers

View solution in original post

ArpitaVK · ‎03-08-2024

Hi @James Chun

That works for me! Thank you for the solution!