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

[Devin Lyons]

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?

[Nic Brough -Adaptavist- · Accepted solution]

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.

[Jack Brickey]

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. 

[Bill Sheboy]

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

[Devin Lyons]

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"

[Bill Sheboy]

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