It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL query to find issues belonging to the team where user is a member of the Portfolio Team

I want a module on my system dashboard that will use a jql query. The query should return all stories and subtasks for the active sprint for that user's team that they are assigned to in Portfolio for Jira no matter the status or who on the team it is assigned to. 

 

S/N am I missing the documentation page with the query items like currentUser(), memberOf(), closedSprints() and the other non-field related functions that are available?

1 answer

0 votes
Marianne Miller Community Leader Oct 24, 2019

You're definitely on the right track!  You will want the filter results gadget on your dashboard.  You'll have to define the query first.

by "belonging to", do mean assigned to?

If so, try 

assignee in membersOf("Portfolio") 

where portfolio = the name of the group

 

If you're looking for issues that this team entered into the system, try

reporter in membersOf("Portfolio")

Im looking for the stories assigned to the team. They could be assigned to a developer in the team or unassigned. They could be reported by a team member, reported by the scrum master, or reported by an outside user. 

Basically I have three teams sharing a project, each using a board filtered by team name.

 

For the dashboard gadget,  I want to filter by current sprint and team for current user.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Advanced Roadmaps

3 short videos to help you get started with Advanced Roadmaps

Hi community, I’m Roi, a product manager working on Advanced Roadmaps for Jira. While Advanced Roadmaps is a powerful tool to plan and track work at scale, we know it can be challenging to get star...

3,528 views 22 15
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you