Creating a report based off of the status of tickets in a Sprint

[William Keen]

We are using two week sprint cycles. After a ticket is worked on and checked in to it's feature branch it is marked "Resolved". Once the feature is merged into the sprint branch it is marked as "Needs QA" and at the end of the two week sprint our product management team runs QA for 3 days. They are changing the status of the tickets from "Needs QA" to either "Passed QA" or "Failed QA". The issue is that in the sprint report these status changes are not visible. The sprint report locks the status of all tickets at the time the sprint ends. For the 3 days they are doing QA the dev team is already on the next sprint.

I need a way to view the status of all of the issues in a sprint that were marked "Needs QA" to see which ones passed and which failed. Is there a way to do this?

[Steven F Behnke · Accepted solution]

Hm, wouldn't the JQL just be:

sprint = $sprintName AND status = "Needs QA"

This should restrict the search to your Sprint Name and only show the status's "Needs QA"

[William Keen]

I've yet to have to do anything complex with Jira; Not super familiar with the toolset yet. We've decided to use versioning along with sprints to get around the issue. So after we close a sprint, we merge each branch into the sprint branch and update the ticket to fixed in version x.x.x; we then use the version report to test everything and change the status to passed or failed and go from there. Thank you for the response though!

[Steven F Behnke]

Yes, in that case you can write query such as

sprint = "ClosedSprintBranch" AND status = "Needs QA" AND fixVersion = "3.5"

sprint in sprintClosed() AND status = "Needs QA" AND fixVersion = "3.5"

This should pull up as all various relevent issues. You can save this JQL query as a Filter, which allows you to link to others, set up a Dashboard with the Filter Results gadget, or paste into Confluence (which generates the list there).

It sounds like your searching needs are well within the grasp of the Advanced Search functionality of JIRA.