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 vote
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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

64 views 0 5
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