It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Answer accepted
Steven Behnke Community Leader 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 Leader 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
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted yesterday in Jira

Upcoming Enterprise releases targeting Q3 2019: Jira Software 8.5 & Jira Service Desk 4.5

Since launching the Jira Software 8.0 and Jira Service Desk 4.0 platform releases in February, many of you have been asking when the next Enterprise release will be so you can take advantage of the m...

270 views 3 6
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