JQL for Linked issues in another project

[Kelly Hansen]

Does anyone know how to do a JQL to show all my issues that have a linked issue from another project?  I seem to only be able to search for a specific linked issue and I dont want to do that as we are trying to build our list for scrum of scrums.  I keep trying to do below and it does not work.

Project = Family and linkedissue ~ "Houses*"

[Chris Rainey · Accepted solution]

Hey Kelly,

Someone may correct me here but I don't believe this is natively possible. To pull this off, I think you'd need an add-on, such as Scriptrunner. 

[Amay Purohit_RVS]

Hi @Kelly Hansen  

Since you are on Jira Premium, did you try out Roadmaps. I am not sure if it can be achieved in Roadmaps but you can give it a try. Or alternatively, if you would be interested in an add-on for this need, you can try out our plugin.

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. Do give it a spin.

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

[Kelly Hansen]

unfortunately roadmaps shows me too much detail.  But I am going to give this a try and see if I can get it to work

[Hannes Obweger - JXL for Jira]

Hi @Kelly Hansen

to the best of my knowledge, @Chris Rainey is correct that this isn't possible natively. The only built-in solution that I can think of is to somehow use Jira Automation to read and process your issues' issue links, and write the result into a custom field; you could then filter by this custom field.

Alternatively, if you're open to solutions from the Atlassian Marketplace, there are apps that can help with this. E.g., I believe that your use case would be easy to solve using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including linked issues, along with many other issue-link-related columns. As you can apply text filtering (including logical operators like OR) to all your columns, you can perform a search like e.g. this in just a couple of clicks:

JXL also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. With these, you can also model much more sophisticated queries and reports that he one above.

Any questions just let me know,

Best,

Hannes