How to find all issues that appear in more than one scrum boards using JQL?

I need to find all issues which are appear in more than one scrum boards by using a JQL query.

2 answers

1 accepted

0 votes
Accepted answer

JQL is for finding issues based on issue data.  Whether an issue appears on a board is not issue data, it is board configuration.

In other words, you can't do it directly.  You'll need to analyze each board query to see where they might overlap.

Nic – makes perfect sense.    

==>You'll need to analyze each board query

I guess the follow-up question is whether or not there is way to query the board meta-data.   The issue that I am dealing with (and perhaps the Nuwan as well).     Is that I cannot start a Sprint – says I need to be a project Admin in another  project (I am not a project admin there, and I cannot reach the person that is).    Since I started my last Sprint, someone must have created a board that queries into my project.    While I know the project, I cannot find either a board (or the filter on which it is based).


How does the "View on Board" link from an individual issue work?   It seems like if I had the union of all boards for all issues in my current Sprint, I would have the "needle" I am looking for. 



Yeah, it's a bit of a pain trying to plough through loads of boards, and there's no easy way to do it. "Need to be admin in another project" is also painful. In most cases, you do need to read the board filter, but there are cases where it's not all you need to check - if an issue is on "Board Dave" and goes into "Sprint 123", then you move it to another project outside Board Dave, then, um, you suddenly need admin in that project to close a sprint that is part of the board. And, yes, it is also possible that someone has created a board including your project that you can't see. The "view on board" is a bit simplistic - it reads the issue and then works through all the board definitions for you. It will give you the right answer, BUT, only if you can see the boards. Which is a nightmare.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,179 views 5 10
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you