Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,317
Community Members
 
Community Events
165
Community Groups

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

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.

Hi @Malka , 

 

have you found a solution for this? 

I'm also looking for this. I want to create one central dashboard which is then automatically adapted for all the teams. 

Kind regards

Like # people like this

It's 2021 and we are still searching folks :) Let's hope that we find a solution someday.

Like Chad Roberts likes this

I would be also interested to be able to query for the "team of the current user"

Like Jonathan likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

174 views 1 3
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