Hey guys,
I had a customer who wanted to edit the existing dashboard. She wants to modify a dropdown menu to display a list of users who are Client Service Managers. In the Dashboard interactive filter setting, the reference table is the user table but I want to change it to the group member table because that will make it easier to filter so that it only displays a list of users who are in the client service manager group. However, after saving the configuration, I got an error that is preventing me from saving it,
Does anyone know why I get that error and how can I fix it?
Changing it to "sys_user_grmember" would not work since if the related dependent filters are pointing to "sys_user" ref.
To solve this, I would do this below. Create a script include to return the sys ids of users that belong to that group and use a script in the condition builder.
javascript: new getGroupMembersUtil().getGrpMem();
javascript: new getGroupMembersUtil().getGrpMem('GroupName'); //You can also do this
Let me know if you have any questions:
Script Include: getGroupMembersUtil
var getGroupMembersUtil = Class.create();
getGroupMembersUtil.prototype = {
initialize: function () {},
getGrpMem: function () {
var groupName = 'Network'; // Change to your target group
var userIds = [];
var group = new GlideRecord('sys_user_group');
group.addQuery('name', groupName);
group.query();
if (group.next()) {
var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('group', group.sys_id);
gr.query();
while (gr.next()) {
userIds.push(gr.user.toString());
}
}
return userIds;
},
type: 'getGroupMembersUtil'
};
Please mark as helpful if this resolves your issue.
