We have a requirement to display the group members of a particular group on a reference field of User table.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-20-2019 08:50 AM
I want to display the name of group members of a particular group to be shown on a reference field to User table. The field's name is "approver ". Only members of a particular group needs to be populated. This is reference field to the User table.Please find the screenshot.
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-21-2019 04:29 AM
Hi Arindam,
Try below Solution:
Script Include Name : GetGroupMembers
API Name : global.GetGroupMembers
function GetGroupMembers(){
var array = [];
var grp = "<sys_id_of_group>" //paste sis_id of group
// gs.addInfoMessage(grp);
var gp = new GlideRecord('sys_user_grmember');
gp.addEncodedQuery('group='+grp);
//gs.addInfoMessage(gp.getEncodedQuery());
gp.query();
while(gp.next())
{
array.push(gp.getValue("user"));
}
gs.addInfoMessage(array.toString());
return 'sys_idIN' +array;
}
Add this reference qualifier to the Approver field
Reference qualifier :
javascript:global.GetGroupMembers();
Regards,
Sanket