How to find linked issues and subtasks?

[Victor Ho]

Hi,

I'm trying to create a search query to do the following.

1. I have a list of tickets with a component = XYZ 

2. I want to search for tickets with component = XYZ and all the linked issues associated with those tickets.

Maybe pseudo code would look like: linkedIssue in (component = XYZ)

Thank you for your help!

[Trudy Claspill]

Hello @Victor Ho 

Welcome to the Atlassian community.

What you want to do is not possible with native Jira functionality. You will need a third party app to execute such a query.

There are multiple third party apps that extend JQL functionality with additional keywords and functions. You can find them in the Atlassian Marketplace. Here is a search link to help you get started:

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

I have used Adaptavist Scriptrunner, and really like that one, but more than one of the available apps will fulfill your needs. In Scriptrunner you would use the linkedIssuesOf function.

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions

[mauricio.groth]

Hi @Victor Ho

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, it’s not possible to find it using only JQL of Jira. You can check a few apps in the marketplace that extend the search for you by clicking here.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find your linked issues associated with issues whose component is XYZ.

issue in linkedIssuesOfQuery("component = XYZ")

Please contact our support if you have any other questions about this query. 

We’ll be happy to help you!
Best regards,
Maurício