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 vote

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,334 views 14 20
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot