Need a Jira JQL Query to find the linked issues

[Asmath Basha]

Need a Jira JQL Query to find the linked issues in the whole project tickets. Kindly help on this.

[Manoj Gangwar]

Hi @Asmath Basha 

To find all the issues with linked issues in a Jira project, you can use the following JQL query:

 project = "YOUR_PROJECT_KEY" AND issueLinkType IS NOT EMPTY

 If you want to filter by specific link types (like "blocks," "is blocked by," "relates to"), you can include the issueLinkType with a specific value, like:

project = "YOUR_PROJECT_KEY" AND issueLinkType = "blocks"

[Asmath Basha]

Hi @Manoj Gangwar thanks for your reply.

• Can we get query for resolved/Closed linked issues. Instead of seeing the Parent tickets, can we get the list of linked issues directly.
• Normally we can export the Linked issues field and can get the list but here the linked issues are from different project. So in the linked issues field the issues won't visible in the filter.
• Any idea on this.

[Manoj Gangwar]

Hi @Asmath Basha 

In this scenario, I would you to to follow the suggestion provided by Charlie. 

key IN (ISSUE-1, ISSUE-2, ISSUE-3, ...) AND statusCategory = Done

If there are too many linked issues to manually input then use the addons like Scriptrunner or JQL search extension.

[Asmath Basha]

Hi @Manoj Gangwar , thanks for the clarification. 

[Charlie Misonne]

Hi @Asmath Basha 

By that you mean all the items having any issue link in a certain project?

By default Jira does not have many JQL functions to query for linked issues.

You can do:

• linkedissue = ABC-123
  To find items linked to ABC-123
• issue in linkedIssues(ABC-123,"is duplicated by")
  to find items linked to ABC-123 with the is duplicated by link type

More on https://support.atlassian.com/jira-service-management-cloud/docs/jql-functions/#linkedissue

I usually use scriptrunner which provides this function:

project = ABC and issuefunction in haslinks()

UPDATE:

nevermind my answer. Manoj provided a better solution.

[Hannes Obweger - JXL for Jira]

Hi @Asmath Basha

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies. These issue hierarchies can be based on Jira's built-in parent/child relationships (like task/sub-task, or epic/story), and/or based on issue links of configurable issue link types. Once you've set up your hierarchy, you can use JXL's various search and filtering techniques to narrow down to the issues you're interested in, like so:

There's a few things going on here - happy to elaborate if that's a direction that might be of interest to you. I should also add that issue hierarchies also play well with JXL's other advanced features, such as sum-ups, conditional formatting, or inline bulk editing via copy/paste.

Any questions just let me know,

Best,

Hannes

[Kristian Walker _Adaptavist_]

Hi Asmath,

If you have either of the ScriptRunner for Jira Cloud or the Enhanced Search for Jira plugins installed, then the linkedIssuesOf() JQL function can help to achieve your requirement.

Regards,

Kristian