Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Running a JQL report in Jira to see how many bugs and stories we completed, by product, for 2023

Michael Troynel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 18, 2024

I am tasked with running a JQL report in Jira to see how many bugs and stories were completed, by product, for 2023. My team has 4 separate products and when we write bugs and stories we include the product name in the title. I want to exclude sub-tasks in the report.

Thank you

2 answers

0 votes
Pablo Vergara
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 19, 2024

Hi Michael,

Looking at the scenario you've described here, I believe you can use a JQL similar to what I show below:

project = General_Testing AND type IN (Bug, Story) AND type NOT IN (Sub-task) AND statusCategory IN (Done) AND (summary ~ "Product_1" OR summary ~ "Product_2")

Of course, you can adapt it to your project, issue types, statutes (or status categories), and product names.

Be aware that using the ~ wildcard will result in a "fuzzy" type of search, so if you have a product name after "Product 1" and another "Product 2" on the summary and you look only for Product 1, it will also return issues where Product 2 is included in the summary.

How to avoid that? Just use non-spaced product names, as shown in my JQL example.

I hope this helps as a guideline!

Regards,

Pablo - Sr. Support Engineer at Service Rocket

Pablo Vergara
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 19, 2024

Oh don't forget to also add the date > startOfYear(2023) and date < endOfYear(2023) earlier suggested by @Nic Brough -Adaptavist- !

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 18, 2024

Welcome to the Atlassian Community!

I do not quite understand "for 2023".  Do you mean "created in 2023", "finished in 203" or a combination of both?

You say "My team has 4 separate products and when we write bugs and stories we include the product name in the title". I assume you mean the summary of the issue?  That is going to make your report unreliable if you try to use it.  Are your users also recording the product name in a reportable field?  A select list custom field, components, by the project they are in?

Ignoring those two questions, the JQL you need is just

date > startOfYear(2023) and date < endOfYear(2023) and summary ~ product-name

But this will give you the problem that ~ is going to miss some stuff and report false positives, unlike a list field which you use "=" to test.

Suggest an answer

Log in or Sign up to answer