Assigned to Interactive Filter that only shows Members of a specific group

[Darrion Burges1]

Hi all,

I'm hoping to create a reference interactive filter that can filter an incident's assigned to field using only the members of a specific group. 

For instance, if my assignment group = x, when a user clicks on the interactive filter, I only want the list to show group members of group x. This is an easy list to achieve using the group membership table, however, I am unable to use this table as the reference table since incidents are assigned to users, not groupmembers. 

Does this mean in order to achieve the interactive filter I'm hoping for I will need to add a column to the user table that lists out each users's group? this way I can filter for group directly on the user table. my concern is that this would be a very heavy column to give every user, and it seems like there is already a link between the user record and the groups that user is a member of when I look at the user profile. 

Thank you in advance for your time and expertise. 

best,

Darrion B

[Abhishek77]

Hi,

There is a field called assignment group already on the incident form right. you can use that field to filter out the incidents assigned to that group.

Why arent you planning to use this field?

[Darrion Burges1]

The group is already embedded into the reports of the dashboard. Our use case is the members of the assignment group trying to narrow down tickets in the same group by assignee. We are trying to limit the selection of people to only those in the designated group.

[Manan Raval]

Hi Darrion,

You can achieve this by writing a script include which queries members from the group member table by passing the assignment group in the advanced reference qualifier or dictionary override like 

javascript: new ScriptIncludeClass().method(current.assignment_group);

In script include you can do GlideRecord to Group member table and return the users of the group.

Regards,

Manan

[Darrion Burges1]

Hey manan, 

This is a great idea! but is this the exact JS I would need? this looks like it find the members of all the current user's groups