What is the JQL query to find out issues in a project that have linked issues of another project?

[Manoj Khaire]

What is the JQL query to find out issues in a project that have linked issues of another project?

[Rahul_RVS_Support · Accepted solution]

Hi @Manoj Khaire 

You can try out our add-on to visualize the progress and status of your complete hierarchy of linked issues, cross project as well, on a single page.

Agile Tools - Epic Tree and Time in Status 

Below are the key features:

• Links Hierarchy upto 10 levels deep
• Progress % on "remaining estimate" or "original estimates"
• Epic Tree on Issue Screen
• Include all issue types vs only Stories in Story Points roll up
• Edit Issue summary, time estimates, story points and assignee on the tree with real time updates in the progress
• Rolled up percentage completion at all levels

The app provides more than 7 types of time in status reports

[Madhumitha N · Accepted solution]

Hello Manoj,

project = ABC AND issueFunction in linkedIssuesOf("project=XYZ")

This should work!

[Manoj Khaire]

Thanks Madhumita.
But getting an error - Field 'issueFunction' does not exist. 

How to resolve this?

[Madhumitha N]

Do you have scriptrunner installed?

https://community.atlassian.com/t5/Jira-questions/I-cannot-run-issueFunction-in-JQL/qaq-p/3899

[Jack Brickey]

You cannot do this 00TB. You can do it with scriptrunner as @Madhumitha N  indicates.

[Bill Sheboy]

Hi @Manoj Khaire 

Adding on to the other suggestions that this feature is not available with out-of-the-box Jira...

How often do you need to perform this check?  If you need it just once, consider exporting the information to a spreadsheet and perform the check there.  If you instead need it often, consider getting a marketplace addon (e.g. ScriptRunner) or building this query dynamically using an automation for Jira (A4J) rule.

Best regards,

Bill

[Manoj Khaire]

@Bill Sheboy I actually want to create an aging dashboard for issues of another project that are linked to issues in my project. So, doing this in spreadsheet will not help, I believe. 

[Bill Sheboy]

Thank you for clarifying, @Manoj Khaire 

As you want this often, the addon seems like the most maintainable approach.