JQL to get linked issues one per line

Question

How to write a JQL that returns all linked issues (associated links) one per line? If Jira standard functions cannot do it, I can use ScriptRunner.

See attached example. For PTD-5419, I would get 3 separate lines:

* PTD-5419 then PTD-2118
* PTD-5419 then PDSEXP-455
* PTD-5419 then Page

Thanks!

Hannes Obweger - JXL for Jira · Answer

Hi @Marco Ferra

if you're open to solutions from the Atlassian Marketplace, this would be easy to do 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 advanced features, including support for (configurable) issue hierarchies; these can be based on Jira's built-in parent/child relationships (like epic/story, or story/subtask), or based on issue links. With this, you can build a view like e.g. this in just a couple of clicks:

In this case, WORK-106 and WORK-107 are connected to WORK-111 via issue links; the same applies to any other parent/child groups in the list. Note that this view is fully interactive, meaning that you can work on your issues directly in JXL (but also trigger various operations in Jira, or export your data to CSV or Excel in just a click).

Since you've tagged your question for Jira Server: As you may have heard, apps sales have ended for Jira Server. Are you planning to migrate to Data Center or Cloud? I'd strongly recommend that. If you need some more time, JXL is perfectly compatible with Jira Server; it's just that we need to generate a license for you. If the above looks interesting, just let me know, and I'll happily start a free trial for you.

Hope this helps,

Best,

Hannes

Pasam Venkateshwarrao · Answer

Hi @Marco Ferra

you can use the below JQL

issue in (linkedIssues(ABC-123),linkedIssues(ABC-234),linkedIssues(ABC-345))

Ste Wright · Answer

Hi @Marco Ferra

Not natively - search lists the results of the actual query, one row per issue - it can't be setup to show the data in your required format.

What's the need you're trying to fulfil? There might be an alternative option for visualising the data in this manner.

Ste