I've seen bits and pieces but not a complete solution. I'm looking for a query that shows issues that were in a closed sprint but do not show up in the backlog - issues in "No man's land" I suppose. Also I noticed that our "official" board backlog count differs from the issue navigator version. Has anyone else seen this?
There is a particular issue that is In Progress that was assigned to a now closed sprint. So it has sprint records but the issue itself is still open. I assigned it to the backlog via API and it shows in the backlog board display along with others for a count of 170. However, if I click the Issue Navigator icon next to the backlog I only see 157 with the default JQL "project = XYZ and sprint is empty ORDER BY Rank ASC". My question is where are the 13 records and how can I find them via JQL?
Ok! the thing is that "project = XYZ and sprint is empty ORDER BY Rank ASC" excludes issues with a recorded sprint. Maybe you can use "project = XYZ and (sprint is empty or sprint in closedSprints() and status not in ("your_done_statuses")) ORDER BY Rank ASC"
This way you'll include the issues in closed sprints AND not in a done_status.
Hope this helps.
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