Find Issues NOT on any agile board

Question

We currently have multiple boards on a single project (multiple teams working in parallel on same product).

I know, it's possible to show the agile boards an issue is placed on:

My question:

Is the inverse possible? Can I display/search for issues NOT shown on any agile board?

Motivation:

While we need to continue working on multiple boards in the same project, we want to do housekeeping and assert, that these boards cover all issues in that project:

* every issue should be displayed on at least one board
* inform board responsibles, if an issue is displayed on multiple boards
(to prevent working in opposite directions)

(If necessary, I am not afraid to use automation rules or even export all board-issue-relations to programmatically compare them against all issues.)

Sunny greetings and thank you

Hartmut

Hartmut Leister · Answer

Hi @Gustavo Félix,

thank you for your suggestion. However, this would still require to retrieve all mappings board->filter (manually).

I think I will have to go with making REST API calls - I'll post a separate answer, once I got the script (not too complicated)

Sunny greetings

Hartmut

Gustavo Félix_5ziaxu · Answer

Hi @Hartmut Leister 
If I understood you correctly, you'd have to do something like this.
https://community.atlassian.com/t5/Jira-questions/JQL-to-list-all-issues-in-specific-quot-kanban-board-quot-or/qaq-p/1247706

After identifying your filter ids, execute a jql with this ids. Something like this "filter not in (10114, 10300) "
And that will give you the ids not present in that boards.

I hope there is an easier way.

Aiden Marriott_za2e2r · Answer

Boards are based on underlying JQL filters so you can probably identify all the issues that are included easily enough (e.g. filter in (... ) ) and maybe compare in excel or try and extend it to some kind of not in JQL