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

[Nuwan]

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

[Nic Brough -Adaptavist- · Accepted solution]

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.

[Mike McGowan]

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. 

[Nic Brough -Adaptavist-]

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.