Sprint Board - JQL query for assignees in a team

[eric caprio]

Hi there,

I am trying to build a board in my kanban project for a software organization that has two teams. The work will be in one sprint for both teams so they would use Active Sprints to see how the work is going... there could be multiple active sprints.

Since there isn't a team filter I see in JIRA in sprint view, my thought is to make a board per team. But I am struggling to figure out what my JQL query is. I tried 

"Team[Team]" = 0c3548f6-d78a-43f2-bd93-74fdab3091b1 AND project = DEV ORDER BY Rank ASC, but I think that is just looking for a sprint assigned to a team vs. what I am looking for is pull in tickets that are assigned to a member of that team.

Thanks!

[Trudy Claspill · Accepted solution]

Hello @eric caprio 

JQL retrieves issues, not sprints. The criteria in the JQL is applied to issues.

Your JQL will retrieve issues in the DEV project where the Team field is set to the Team you specified.

One thing to note is that if you use subtasks, the subtasks will also need to be assigned to the team. Otherwise the subtasks will not be retrieved by the JQL.

There is no method currently available to select tickets based on the Assignee being a member of a specified team. Essentially what you would need is:

Assignee in membersOf(<Team>)

...and that currently is not supported. Refer to  https://jira.atlassian.com/browse/JRACLOUD-81400

So, you can either

1. use the Team field to indicate the Team to which an issue is assigned, without regard for the user actually named in the Assignee field
2. Use a JQL with criteria for the Assignee field that explicitly lists all the members of the team; i.e. Assignee in (user1, user2, user3)

[eric caprio]

thank you, @Trudy Claspill