How can I show "Linked work items" in JQL or a report

[Raj Reddy]

How can I show "Linked work items" in JQL or a report.

For example, If I have a Business Story ABC123 and it has 6 Tasks connected to it via "Linked work items" which could have status as"is implemented by" or "is tested by" etc. 

This JQL or report should show me:

Story, Linked work items status, Task

Thank you.

[Trudy Claspill]

Hello @Raj Reddy 

That is not possible with only native Jira functionality. JQL results are not capable of showing the information for an item and the items linked to it in one row.

You could construct a query that would show the item and the items linked to it as separate rows. That query would be:

key={a single issue key} or  issue in linkedIssues("{a single issue key}")

ref: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#linkedWorkItems--

The linkedIssues() / linkedWorkItems() JQL function requires that provide a single, hard-coded work item key. You cannot, for example, provide a filter to the function to dynamically specify a list of items for which you want the linked work items:

issue in linkedWorkItems("project=X and type=Y")

Are you open to considering a third party app to solve your need?