Find with JQL tasks outside a project

[Eran Roiter]

Hello everyone.

I want to run a query that will give me all the tasks that link to tasks within my project but the tasks themselves are in other projects.
Does anyone have an idea what the effective / existing solution is.

Thank you :)

[Bill Sheboy]

Hi @Eran Roiter 

That is not possible with out-of-the-box features of JQL.  It cannot perform such sub-queries or joins.

Solving this scenario depends upon how frequently you need to do this, and your willingness to purchase addons for Jira Cloud:

• need this one-time, or infrequently
  • Export the issues in your project to a spreadsheet, and use spreadsheet functions to parse the link data to find the issues in other projects
• need this often, and have money to spend
  • Investigate marketplace addons which add this searching capability to JQL
• need this often, there are fewer than 100 issues with links, and have no money to spend
  • Create an automation rule to identify the issues

Kind regards,
Bill

[Pradeep]

Hi @Eran Roiter 

If you are fine to try out a mktplace app you can have a look at the one we have built for the same use case.

Issue Hierarchy  

You can view all the linked issues across diff projects in a single view.

The app is free upto 10 users. Do try it out.

Disclaimer : I am part of the team which developed this app

[Charlotte Santos]

Hi @Eran Roiter 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find tasks from one project that are linked to the other tasks in your project:

issue in linkedIssuesOfQuery("project = ABC AND type = Task") AND project = DEF AND type = Task

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

We’ll be happy to help you!