Get the Users of specific Group

Rakshanda Kunte · ‎11-01-2023

Hi All,

I have 2 field Members (List Collector) and Group Name (Reference) in a catalog item.

Whenever a requester selects a group so in the Member field the list of users in who is part of that group should populate as options to select.

Kindly, help with the scripting.

Thank you..!!

Ankur Bawiskar · ‎11-01-2023

@Rakshanda Kunte

something like this in advanced ref qualifier

javascript&colon; var query;
var arr = [];
var gr = new GlideRecord("sys_user_grmember");
gr.addQuery("group", current.variables.group_name);
gr.query();
while (gr.next()) {
   arr.push(gr.getValue('user'));
}
query = 'sys_idIN' + arr.toString();
query;

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

View solution in original post

Rakshanda Kunte · ‎11-01-2023

@Vishal Birajdar

Should script Include client callable or no?

Vishal Birajdar · ‎11-01-2023

Hi @Rakshanda Kunte

No, it should not as we are calling it from reference qualifier...!!!

Vishal Birajdar
ServiceNow Developer

I know one thing, and that is that I know nothing.
- Socrates

Ankur Bawiskar · ‎11-01-2023

@Rakshanda Kunte

no script include required.

Did you check my above response? It will work fine for you

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