Hello, I'm working on creating a new dynamic filter option using a script include to populate a list of users matching certain criteria into a filter condition. For any user with an admin role, it works exactly as expected. For any non-admin user, it seems to bomb out and return far too many results, almost as if it is not being passed the current user's sys_id like it should be.
Anybody happen to have any idea why that would be?
Note: The script include I would rather not change if possible, as it is used for generating approval requests.
Dynamic filter condition on the user table:
Script include (client callable):
function GetChangeCoordinators(userObject) {
// Get itil group type
var groupType = new GlideRecord('sys_user_group_type');
groupType.get('name', 'itil');
// Get groups the submitter is a member of
var groups = new GlideRecord('sys_user_grmember');
groups.addQuery('user', userObject);
groups.addQuery('group.type', groupType.sys_id); // Filter groups to get team groups by checking Type
groups.query();
// Get members of those groups
var users = [];
while(groups.next())
{
var otherMembers = new GlideRecord('sys_user_grmember');
otherMembers.addQuery('group', groups.group);
otherMembers.addQuery('user', '!=', userObject); // Filter users to exclude submitter
otherMembers.query();
// Add members's sys_id's to array
while(otherMembers.next())
{
users.push(otherMembers.user.sys_id.toString());
}
}
// Filter array of users for unique entries
var arrayUtil = new ArrayUtil();
users = arrayUtil.unique(users);
// Check which of those users have the Change Coordinator role and add them to an array
var changeCoordinators = [];
for (var index = 0; index < users.length; index++)
{
var userHasRole = new GlideRecord('sys_user_has_role');
userHasRole.addQuery('role.name', 'change_coordinator');
userHasRole.addQuery('user', users[index]);
userHasRole.query();
if (userHasRole.next()) { changeCoordinators.push(users[index]); }
}
return changeCoordinators;
}
