nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL query for linked issues in a specific project

Andy Keyworth_kojcja

Hi, I have been trying to build a JQL query that can search within a given project, for all linked tickets that are in another project.

For example, we have a DAILY ("Daily Remediation") project, and it can be linked to one-to-many PRO tickets. What I want to build (but haven't been able to) is a query similar to:

project = "Daily Remediation" and status != Closed AND linkedIssues IN linkedIssues("PRO").

I know that won't work, but it's the idea of what I want to define.

Accepted answers

Trudy P Claspill

Hello @Andy Keyworth

Welcome to the Atlassian community.

Jira does not support what you want to do natively. There are third party apps that would support that.

Are you willing to consider a third party app to meet your need?

Prosper Agwegiokhe

Hi @Andy Keyworth ,

I’m Prosper, a support engineer at Appfire, and I’m here to help you. As @Trudy P Claspill as said, you can't achieve the desired result using native Jira advanced search alone.

If you are open to 3rd party solutions, the app I work for, JQL Search Extensions for Jira, you can use the query below to get the results for your use case:

issue in linkedIssuesOfQuery("project in (PRO)") and project = "Daily Remediation" and status != Closed

This query will return issues in the project Daily Remediation that have links to project PRO.

You can see more information about this query here, and please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,
Prosper.

Madhu_RVS

Hi @Andy Keyworth

Welcome to the Atlassian community !!

As everyone suggested, if you would like to try out an add-on for this use case, pls take a look at

Issue Hierarchy

The app shows your issue hierarchy in a tree view created through Issue Links. The Issues in the tree can be in multiple projects and the app will pull out each one of them and show you a structured hierarchy.

The app has multiple other features which are very useful in project tracking and management.

(Disclaimer: I work on RVS, the vendor for this app)

Links Hierarchy - New.PNG

All comments

Trudy P Claspill

Hello @Andy Keyworth

Welcome to the Atlassian community.

Jira does not support what you want to do natively. There are third party apps that would support that.

Are you willing to consider a third party app to meet your need?

Prosper Agwegiokhe

Hi @Andy Keyworth ,

issue in linkedIssuesOfQuery("project in (PRO)") and project = "Daily Remediation" and status != Closed

We’ll be happy to help you!

Best regards,
Prosper.

Madhu_RVS

Hi @Andy Keyworth

Welcome to the Atlassian community !!

As everyone suggested, if you would like to try out an add-on for this use case, pls take a look at

Issue Hierarchy

The app has multiple other features which are very useful in project tracking and management.

(Disclaimer: I work on RVS, the vendor for this app)

Links Hierarchy - New.PNG

Andy Keyworth_kojcja

Thank you Trudy,

Personally, I am happy to consider a third-party solution; I just have to rationalize it "upstairs".

Thank you again, I really do appreciate the clarification,

Andy

Andy Keyworth_kojcja

Thank you Prosper

Personally, I am happy to consider JQL Search Extensions; I just have to rationalize it "upstairs".

Thank you again, I really do appreciate the clarification,

Andy

Andy Keyworth_kojcja

Thank you Madhu,

Personally, I am happy to consider Issue Hierarchy; I just have to rationalize it "upstairs".

Thank you again, I really do appreciate the clarification,

Andy

Trudy P Claspill

Besides the apps mentioned by others, ScriptRunner Enhanced Search also has a function that would meet your requirement.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud