The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Query and reporting based on groups

Ian Templeton
Contributor
October 14, 2024

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!

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

3 votes
Answer accepted
Trudy P Claspill
Community Champion
October 14, 2024

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
Contributor
October 14, 2024

Thanks @Trudy P Claspill

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

Like Trudy P Claspill likes this
TAGS
AUG Leaders

Atlassian Community Events