Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Filter for multiple boards in one project

Raj Reddy September 29, 2021

Hello,

I have a regular Scrum Board and a Kanban Board in one project.

Here are my 2 questions:

1. I am trying to see if I can write 2 different JQL Query/Filter to see all the issues (Epics/Stories/Tasks etc.) separately for these 2 boards - Scrum Board and a Kanban Board.

2. Can I write one query/Filter to see all the issues (Epics/Stories/Tasks etc.) for these 2 boards - Scrum Board and a Kanban Board; in one report/filter.

I guess, if we can answer 1 then the answer for 2 should be easy. In other words, I am looking for what is the field name for Board to verify in the Filter (or I could be wrong)?

Thank you very much in advance.

Raj Reddy

1 answer

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 29, 2021

Hi @Raj Reddy 

A board is a view of a project's issues using a filter.  If you already have two boards (...and they work as you expect) then you already have the filters.  Please look at your board settings to find them.

To make the combined filter, just look at your two board filters to learn what separates the issues for the views (e.g. components) and remove those distinctions.

Kind regards,
Bill

Raj Reddy October 1, 2021

Hello Bill,

First of all thank you very much for your reply.

That was my first instinct too. Unfortunately, it does not. Here is how it shows:

----------------------------

Scrum Board:

Board Name: AN Board

Filter Queryproject = AN ORDER BY Rank ASC

Kanban Board:

Board Name: Analytics Product Management Board

Filter Queryproject = AN ORDER BY Rank ASC

----------------------------

With no other simple way (Board field name), the solution I am using is based on the "Status" as they differ in both the boards.

Thank you again,

Raj Reddy

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 1, 2021

The key difference between the Scrum and Kanban boards is that the Scrum one only displays issues in the current/active sprint.  Team may add other criteria when sharing a project, as I noted using component or label field values.  Board name is not a field  or anything which can be queried.

If you want to use JQL (outside of the boards) to see as you describe, use the sprint field and status values as the differences:

project = AN AND sprint IN openSprints() ORDER BY Rank

project = AN AND sprint IS EMPTY AND status IN (list of status values you note are different) ORDER BY Rank

Raj Reddy October 1, 2021

Understood. I am using the "Status" and it serves the purpose. 

Thank you, Bill

Raj

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer