JQL filter to show Bugs linked to Stories - help?

[Mandy Froelich]

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]

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]

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 Claspill]

Hello @Mandy Froelich 

Welcome to the community.

Jira does not natively support creating filters that will give you the details for issued linked to the issues that are the target of your search.

Are you open to adding third party apps to your instance?

[Trudy Claspill]

Additionally, Jira does not provide a native JQL function for searching for issues that have links of a particular type or to a particular type of issue.

In general, you may find this page concerning available JQL functions useful.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

There are several associated pages that cover advanced searching topics that you might also find useful.

[Mandy Froelich]

Hello, 

Thanks for the information. As for the third-party application, possibly. What do you suggest? 

Thanks,

Mandy 

[Trudy Claspill]

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.