Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL to get linked issues one per line

Marco Ferra
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 4, 2023

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

 

example_1.png

Thanks!

3 answers

0 votes
Hannes Obweger - JXL for Jira
Atlassian Partner
August 21, 2023

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:

issue-link-hierarchy.gif

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

0 votes
Pasam Venkateshwarrao
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 4, 2023

Hi @Marco Ferra 

 

you can use the below JQL

 

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

0 votes
Ste Wright
Community Champion
August 4, 2023

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

Suggest an answer

Log in or Sign up to answer