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.
Hi,
Can you show me the related list of your interactive filter? I was able to reproduce same interactive filter on my instance and it looks good.
Hi,
Do you mean this?
Orginally, it was this before I tried to change the reference table to group member table.
I got a similar error when I tried adding change_task opened by to as a related list reference to "sys_user_grmember" interactive filter.
I suspect that one of your related list for "Interactive Filter References" is not allowing you add this.
Try to do this.
Create a new Interactive Filter and use sys_user table. When I used "sys_user_grmember" it is returning sys ids to me which is not usable in the dashboard.
Let me know if this helps.
So you are saying that I can't modify from sys_user table to sys_user_grmember in the reference table even though I am using the User reference field? Is there nothing to fix except start over to create an interactive filter? Here is what it looks like in the dashboard,
