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

This widget could not be displayed.
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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

165 views 2 0
Join discussion

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