JQL filter to show Bugs linked to Stories - help?

Question

Hello,

I'm still familiarizing myself with JQL queries and would like to create a filter that shows the current sprint with any issues of the issuetype "bug" linked to a "story" issue in the same sprint.

It should show the creator of the bug issue and how many story points are in the linked issue. This would only show results for issues in the current sprint.

Input welcome on how to achieve the end result, as I've played around with many variations but would like the help of someone more experienced.

Thanks!

Rahul_RVS · Answer

Hi @Mandy Froelich

For a ready made solution, you can try out our add-on

Issue Hierarchy Reports

And generate insights such as:

- View the full Jira Issue Type hierarchy of Linked issues

- % complete based on time spent and story points at each hierarchy level

- Sum up Time Spent, Org Estimate, Time Rmng, custom number
fields

- Export your reports to a CSV file

mauricio.groth · Answer

Hi @Mandy Froelich,

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

Using this query will show the current sprint with any issues of the issuetype "bug" linked to a "story" issue in the same sprint:

sprint = 1 and type = bug and linkedIssueType = “story”

Check out the documentation for more examples.
I hope this helps!
Maurício

Trudy P Claspill · Answer

There are several apps that extend JQL functionality in different ways.

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=jql%20extend

You'll need to take a look at the functionality of each and the cost to decide which is best for you.