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

Question

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

Pablo V. · Answer

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

Pablo V. · Answer

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

Nic Brough -Adaptavist- · Answer

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.