Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

2 answers

2 accepted

0 votes
Answer accepted

Hello Manoj,

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

This should work!

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

How to resolve this?

Jack Community Leader Jun 17, 2021

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

Like Bill Sheboy likes this

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

Like Madhumitha N likes this

@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. 

Like Bill Sheboy likes this

Thank you for clarifying, @Manoj Khaire 

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

0 votes
Answer accepted

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

 

Links Hierarchy.png

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you