Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Is there an equivalent to openSprints() in JQL for Kanban?

I have kanban boards in several projects and I am trying to write a filter that gets all of the issues currently on the board. In scrum, you can do this with the openSprints() function. Is there something similar for kanban?

2 answers

1 accepted

0 votes
Answer accepted

Welcome to the Community!

No, the question cannot make sense.  Kanban boards do not have sprints, so "issues in the sprint for this board" can't be done.

Now, a Kanban board could be looking at issues that are included in Scrum sprints, so you can report on sprints while looking at a Kanban board, even though they're not relevant to the board.  But you run into the second problem with the question in that boards do not contain issues, they are a selection of issues.  There's no function for "is on board" because issues are not contained by boards.

You can build the query you want though.  First, look at the query for the Kanban board.  Take a copy of it, and, exactly as you suggest, add "sprint in openSprints()" to it.

1 vote
Jack Brickey Community Leader Jan 05, 2022

The only option here would be to search by status and even then there can be some overlap where some to do items may appear in both locations depending on your config. 

Hi @Devin Lyons -- Welcome to the Atlassian Community!

Yes, and...to what Jack notes: 

Which issues do you care about?  If you only care about "in progress" you could use the following:

project IN (projectA, projectB, projectC) AND statusCategory = "In Progress"

 

Kind regards,
Bill

I am looking for all issues that are in an active sprint or on a kanban board and not done. In JQL, it would look something like this:

 

(sprint in openSprints() OR sprint in kanbanBoards()) and status != "Done"

Ignoring the "sprint" part of your example for a moment, please consider each Kanban team has a board with a filter describing their flow/issues.  If you identify each filter ID number you may OR the results. 

I added an exclusion for "To Do" in case you are using a Kanban backlog.  Please remove that if you do not use Kanban backlogs.

(filter=1234 OR filter=5678 OR filter=9012) AND status NOT IN ("To Do", "Done")

You can then OR that entire expression with your sprint team's information

Like Jack Brickey likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

832 views 25 28
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you