JQL query for linked issues in a specific project

[Andy Keyworth]

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.

[Prosper Agwegiokhe · Accepted solution]

Hi @Andy Keyworth ,

I’m Prosper, a support engineer at Appfire, and I’m here to help you. As @Trudy 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.

[Andy Keyworth]

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

[Madhu_RVS · Accepted solution]

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)

[Andy Keyworth]

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 Claspill · Accepted solution]

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?

[Andy Keyworth]

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

[Trudy Claspill]

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