Query and reporting based on groups

[Ian Templeton]

In JSM, we have teams that are a mix of FTEs, vendors and interns. I would like to be able to query and report on a specific subset of people (i.e. FTE) on the "Assigned Team" w/out listing each person specifically, which requires multiple updates when people join or leave the team. 

Is it possible to query and build reports based on a group's membership?
Example: "Assigned Team" = Doers and assignee = Doers-FTE-Group

If so, how?

Thanks in advance!

[Trudy Claspill · Accepted solution]

Hello @Ian Templeton 

Welcome to the Atlassian community.

What type of field is "Assigned Team"? Is that a User Group Picker field?

Do you have Jira integrated with a IdP so that you are getting user groups from an outside source that supports group/membership nesting? If so then you could use that to build a user group structure such as

Doers
|-- Doers-FTE-Group
    |-- individual users
|-- Doers-Vendors-Group
    |-- individual users
|-- Doers-Intern-Group
    |-- individual users

Using Atlassian Cloud to create user groups directly does not support the above style of nesting groups within groups.

If you have grouped the users into user groups then for a field like Assignee you can use membersOf()

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#membersOf--

assignee in membersOf("Doers-FTE-Group")

That would retrieve all issues where the Assignee user is currently a member of the user group "Doers-FTE-Group".

[Ian Templeton]

Thanks @Trudy Claspill

We use Azure AD for our idP. assignee in membersOf("") does the trick. Thank you!