reference field to return only users from a specific group

[JJG]

Hello, 

I have a reference field to the 'sys_user' table with the name 'name_of_recruiter'. I want the reference field to only show users who are in the recruiting group. However, it is returning every user. Is my script incorrect?

Script include:

var GetGroupMember= Class.create(); 

GetGroupMember.prototype = { 

getMember : function() { 

var x = 'e4d875a8db9a5300e21cfd131d961992'; //This is the sys_id of the recruiter group 

var user_array = []; 

var getMembers = new GlideRecord('sys_user_grmember'); 

getMembers.addQuery('group',x); 

getMembers.query(); 

while(getMembers.next()) { 

user_array.push(getMembers.user + ''); 

}

 return user_array.toString(); 

}};

Reference qualified in the 'sys_user' reference field 'name_of_recruiter'

 javascript:new GetGroupMember().getMember();

[JJG]

SOLVED: there was a single space in front of the reference qualifier, thank you for all your help mark, your code works!

[BiancaK]

Thanks @Mark Roethof this worked for me as well - thanks for your help!

[BiancaK]

Thank you for sharing your screenshots and for the question - I had a similar question and this thread worked for me as well. Appreciate

[Mark Roethof]

Just reproduced also with your code and the slight adjustment (+ obviously used a different sys_id). Works fine here.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list