- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2025 10:35 AM
Hey All,
I feel that I am missing something and I'm not sure what it is.
Here's my advanced reference qualifier on my catalog variable reference the sys_user table.
javascript: new getGroupMembers().getGroupMembersForIT(current.variables.assignment_group);
Here's the script include, which is global, client callable.
var getGroupMembers = Class.create();
getGroupMembers.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getGroupMembersForIT: function(assignmentGroup) {
var arr = [];
var grp = new GlideRecord('sys_user_grmember');
grp.addQuery("group", assignmentGroup);
grp.query();
while (grp.next()) {
arr.push(grp.sys_id.toString());
//gs.info("This are the values for the arr: " + arr);
}
return 'sys_idIN' + arr.toString();
},
type: 'getGroupMembers'
});
What am I doing wrong?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2025 10:47 AM
You are returning sysids of group members table
But you should return user sysids
var getGroupMembers = Class.create();
getGroupMembers.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getGroupMembersForIT: function(assignmentGroup) {
var arr = [];
var grp = new GlideRecord('sys_user_grmember');
grp.addQuery("group", assignmentGroup);
grp.query();
while (grp.next()) {
arr.push(grp.user.toString());
//gs.info("This are the values for the arr: " + arr);
}
return 'sys_idIN' + arr.toString();
},
type: 'getGroupMembers'
});
Try this
Regards
Chaitanya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2025 06:23 AM
I just had to redo it. I think there was something wrong with my update set. I backed it out and now it is working!
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2025 06:27 AM
Cool @0890KM ,
Glad it's working now
Could you please accept the appropriate response as a solution and close the thread
it will help for the future readers
Please mark my answer as helpful/correct if it resolves your query.
Regards,
Chaitanya