JQL- Filter completed issues in a specific sprint by category

Trying to get some metrics that can be displayed,

Under Agile -> [BoardName] -> Sprint Report I can pick a sprint and there's 3 tables: "Completed", "Not Completed" and "Removed"

My end goal is to get everything from this "Completed" table and produce some metrics from there based on the catagory it's in (Software, Hardware etc...), but I can't seem to find a JQL Query that covers it.

When I view the table in the issue navigator it just calls each individual Key using:

"issueKey in ([Massive list of each individual issue key])"

My own experimenting and google have failed me, so I'm turning to here for help, if any more detail's needed... Let me know!

3 answers

1 accepted

Hi Ambler, 

As I could understand you need something similar to this:

sprint = "Your Sprint Name" AND category = "CategoryName" AND status = completed 

Did you try it? Oh, if your JIRA is any version prior to 6.1.3 you must search the sprint by ID number. See page below if that's your case:

https://confluence.atlassian.com/display/JIRAKB/JIRA+Agile%3A+How+to+search+for+a+Sprint+using+JQL

Hope this helps you.

Cheers

Hi Thiago, thanks for the reply. The problem I'm having is that I cannot find a filter that will give me everything in the "Completed issues" column, (see http://puu.sh/kmj2R/1fd0206667.png for an example of the column in the Sprint Report) There's 96 results there (Not all shown), and those are the ones I want to work with, but I can't find a way to filter those out using JQL, they all share some attributes with stuff in the Not Completed/Removed From Sprint categories. It's either something really silly that I'm missing or something wrong with the way we've set it up that's stopping this working, but that page has a way of filtering out the "Completed" ones and I can't work out what it is. Thanks

Turns out this is the correct way to do it normally, however due to the way it'd been set up in my scenario I couldn't. All working with a few changes, thanks!

Try:

resolution is not EMPTY

resolution != empty

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

432 views 1 14
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot