- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 weeks ago - last edited 2 weeks ago
var grUser = new GlideRecord("sys_user_grmember");
grUser .addQuery("group", current.u_assignment_group);
grUser .addQuery('user', '!=', current.u_assigned_to);
grUser .query();
var querStr = '';
while (gr.next()) {
if (querStr == '') {
querStr = 'sys_idIN' + grUser .getValue('user');
} else {
querStr += ',' + grUser .getValue('user');
}
}
return querStr;
},
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
Hi @ishwarsingh
in your code you've started with "var grUser = new GlideRecord" and in your "while" loop you've inserted "while (gr.next()) {". This is not correct
May you try
var grUser = new GlideRecord("sys_user_grmember");
grUser.addQuery("group", current.u_assignment_group);
grUser.addQuery("user", "!=", current.u_assigned_to);
grUser.query();
var querStr = '';
while (grUser.next()) {
if (querStr == '') {
querStr = 'sys_idIN' + grUser.getValue('user');
} else {
querStr += ',' + grUser.getValue('user');
}
}
return querStr;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
This should be handled already out of the box. If you right click on the assigned to field then on the dependent field tab assignment_group should be listed already. This will limit the assigned to only show the group members. At least that is what I think you are asking. If I'm incorrect please see give more details.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
Hi @ishwarsingh
in your code you've started with "var grUser = new GlideRecord" and in your "while" loop you've inserted "while (gr.next()) {". This is not correct
May you try
var grUser = new GlideRecord("sys_user_grmember");
grUser.addQuery("group", current.u_assignment_group);
grUser.addQuery("user", "!=", current.u_assigned_to);
grUser.query();
var querStr = '';
while (grUser.next()) {
if (querStr == '') {
querStr = 'sys_idIN' + grUser.getValue('user');
} else {
querStr += ',' + grUser.getValue('user');
}
}
return querStr;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
these is right solution you have given to me
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
and when we select assigned to user so in assignment group only that group we have to see in which a user is member of that group not all group