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

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?

1 answer

1 accepted

0 votes
Accepted answer
Steven Behnke Community Champion Aug 04, 2014

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"

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 Behnke Community Champion Aug 04, 2014

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.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,323 views 12 19
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you