How can I return or filter by data for issues linked to the issues I'm querying for?

[Taylor Hayes]

We created linked issue relationships to bugs where we link the issue that caused the bug as the "is caused by" issueLinkType. I want to be able to query and see what teams, developers, QA Testers are working on these issues that cause bugs so we can determine if there are any process improvements to make to lessen the frequency of bugs being released to production. 

I'm struggling to find the right way to craft this query.

Here are the two approaches I've taken:

1. Query for the issues that have caused bugs.

issueLinkType = causes and project = BLAH and "QA Tester" = JOE

Problems:

• issueLinkType = causes is used to link issues to other non-bug issues, so I need the ability to say something like "and linkedIssuesIssueType = Bug" but I haven't found a way to do that.

2. Query for the bugs themselves that have issueLinkType = "is caused by"

issueLinkType = "is caused by" and project = BLAH and issuetype = Bug

Problems:

• I need to be able to return various attributes such as "QA Tester" or "Dev Lead" for the issues that are linked to the bug with the "is caused by" relationship.

I'd really like to avoid having to do some complicated excel work to return this data and just have JQL support my use case.

[Hannes Obweger - JXL for Jira]

Hi @Taylor Hayes

welcome to the community!

To the best of my knowledge, this isn't possible in native Jira/JQL.

This being said, if you're open to solutions from the Atlassian Marketplace, you'll have more options available. E.g., your use case should be easy to solve using the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your work items (issues) that allows viewing, inline-editing, sorting, and filtering by all your work item fields - including your work item links - much like you’d do in e.g. Excel, Google Sheets, Smartsheet, or Airtable. 

Finding the work items you're looking for in JXL would be as easy as this:

Once you've narrowed down your list of work items, you can work on your work items directly in JXL, trigger various operations in Jira, or export your work items with just one click.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Rahul_RVS]

Hi @Taylor Hayes 

Welcome to the community !!

Not sure if this can be achieved out of the box in Jira. If you are open to try out a mktplace solution for this need, I can suggest 

Issue Hierarchy 

The app allows you to view your project issue links (cross projects as well) in a tree view. You can also view %complete progress at each parent level. It sums up the time tracking fields, story point or numeric fields at each parent level. The app can be added to a dashboard as well.

Disclaimer : I am one of the app team member

[Trudy Claspill]

Hello @Taylor Hayes 

Welcome to the Atlassian community.

Jira does not natively have the capability to create the filter you describe. Doing so requires a third party app that extends the JQL capabilities, such as Enhanced Search from Adaptavist

There are multiple third party apps that can provide a JQL function linkedIssuesOf(<subquery>) where you can construct the filter you want; i.e.

Project = X and Tester = Joe and issuefunction in linkedIssuesOf("issuetype=Bug", "is caused by")

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/scriptrunner-enhanced-search-jql-functions/links-and-relationships#linkedissuesof

You may already have an app that extends JQL capabilities. Check with your Jira Admins to find out, and to ask if getting a third party app for this is an option.