var assignedTo = current.assigned_to.toString(); // Important: Convert to string
var userGroups = [];
var grMember = new GlideRecord('sys_user_grmember');
grMember.addQuery('user', assignedTo);
grMember.query();
while (grMember.next()) {
userGroups.push(grMember.group.toString()); // Add group sys_ids to the array
}
if (userGroups.length === 0) {
// The user is not in any group, so return an empty string to show no groups.
return '';
}
// Build the query for the Assignment Group table.
var query = 'sys_idIN' + userGroups.join(','); // Efficient "IN" query
return query;
Advanced reference qualifier script shows assignment groups based on who is assigned to
Working Code Asked question February 22, 2025
Sorry, you do not have permission to read comments.