nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL to list all issues in specific "kanban board" or "scrum board" by board name

Bishnu Prasad Pandey

I want to create a filter which will list all the issues that are present in specific kanban board in a project. Please help me to write filter to do so. ( "project name" and "board name")

Accepted answers

Ste Wright

Hi @Bishnu Prasad Pandey

The easiest method of doing this is to search via the filter ID, as the board is a visual representation of a filter. To do this:

Go to the Board in question
In the top-right, select Options (3-dots) and choose Board Settings
Go to the General tab on the left-hand menu
Select "Edit Filter Query"
In the URL, take a note of the filter's ID; it will look like this - ?filter=XXXX - take the numbers after the equals
Now go into Issue Search and you can enter something such as: project = ABC and filter = XXXXX - that will let you search by project and "board"

Ste

All comments

Ste Wright

Hi @Bishnu Prasad Pandey

The easiest method of doing this is to search via the filter ID, as the board is a visual representation of a filter. To do this:

Go to the Board in question
In the top-right, select Options (3-dots) and choose Board Settings
Go to the General tab on the left-hand menu
Select "Edit Filter Query"
In the URL, take a note of the filter's ID; it will look like this - ?filter=XXXX - take the numbers after the equals
Now go into Issue Search and you can enter something such as: project = ABC and filter = XXXXX - that will let you search by project and "board"

Ste

Mario Rodriguez Redondo

Hi @Bishnu Prasad Pandey if you want to retrieve the issues on a specific Board, go to the Board > Configuration > General > search for the saved Filter Query.

Example: project = 31354 AND component = "xxxxxxxx" ORDER BY Rank ASC

Each board has it's own, and it the same filter you can save in order to access the issues on the current Board.

Hope this helps you.

Kind regards.

Bishnu Prasad Pandey

Thank you Stephen

Bishnu Prasad Pandey

Thank you Mario

Nuria Llobera_pxo55f

Hi Stephen,

that solution would work for classical projects. How can I create a filter of issues on a board of a next-gen project?

Best,

Nuria

Ste Wright

Hi @Nuria LLobera

You can just search by Project Key to see which issues are on a Next-Gen Board - as the board's filter is all project issues at this time.

You could filter out "Done" if you prefer, to show only open issues.

If you're asking how to create a board filter for Next-Gen, that's not yet available. For this I would suggest voting/watching the ideas JSWCLOUD-17444 and JSWCLOUD-17331 - which cover filters and board settings for Next-Gen.

Ste

Michal Jurasek

Hi @Mario Rodriguez Redondo

I have set up the Filter Query on the board with component and it helps with the issues on the Kanban board but still see all issues in the project under Issues = the filter query is not reflected in the Issues.

I am on Jira v7.13.8

Thanks Michal

Danny Bish

Unless you use a custom field, label or component to tag each issue on the board (and in the query), the only option I have found is to use versions/releases or Epics to add to the filter. It would be great if it were easier, but so far this is the world we live in.

One additional thought (outside of something more complicated with automation and scriptrunner) would be to link all issues to something and check for it as a subquery:
project = "CBA" and issue in linkedIssues("CBA-111") ORDER BY RANK ASC

Good luck.

Michal Jurasek

Thank you Danny

nathalie.willems

What's the component field? How can find its value for a specific Kanban board?

Rich Bayless

It's such a shame that all of the answers given so far are simply workarounds to Jira's apparent limitation of not being able to specify a specific board (or boards) in the JQL itself (as the op actually asked). And, none of those workarounds support searching across multiple specific boards. For example, if my project has twenty boards, and I want to find all issues from just five specific boards (of my project) which meet a specific set of criteria, there's apparently no way to do that. Even worse, it's been over four years since this question was asked and Jira still doesn't offer a solution for what should be super simple (e.g., "AND Board = ________"). {sigh}

What's especially bizarre about this limitation is that Jira does support specifying a specific board in REST queries (e.g., to get the internal IDs of all sprints for a specific board: https://{jira site/instance}/rest/agile/1.0/board/68696/sprint) ... how did Atlassian manage to add such support for REST but not JQL?!?!?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud