nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL for Linked issues in another project

Kelly Hansen_w1d7q2

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*"

Accepted answers

Chris Rainey

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.

All comments

Chris Rainey

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.

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

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)

Links HIerarchy.PNG

Kelly Hansen_w1d7q2

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

nreddy_0pagp9

Thanks @Hannes Obweger - JXL for Jira , using JXL worked much better than using script runner. The script runner query was strangely VERY slow.

Hannes Obweger - JXL for Jira

Hi @nreddy,

thank you for your kind words - great to hear that JXL works so well for you! Please don't hesitate to reach out to us at https://support.jxl.app if there's anything we can assist with!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud