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?
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.
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"
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
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...
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