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; } } }

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

Raj Reddy_zu1v5p

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.

Accepted answers

All comments

Trudy P 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?

mr john_8cmnbt

Interesting question! I’ve been looking for a way to pull “Linked Work Items” into JQL or reports as well. Ideally, the report would show the Story, each linked task, and its status, including link types like “is implemented by” or “is tested by.

Has anyone found a clean way to do this in JQL or using built-in reporting? Or do we need an add-on like Structure or eazyBI to get this view?

Danut M _StonikByte_

Hi @Raj Reddy,

In Confluence, you can add the Jira Work Items macro and configure it to display the Linked Issues column; as a result it will display the keys of the linked issues.

But unfortunately they do not display additional details about the linked issues such as Summary, Description or Status...

If this is not enough, a solution would be to install an app ( plugin) from Atlassian Marketplace that offers a better view over the issues and linked issues.

If you consider using a plugin, I would recommend using the Work Breakdown Structure macro offered by our Great Gadgets for Confluence app.

This gadget can display the issue from a JQL or filter (cross-project) along with their linked issues, which have also their Summary, Status and Type displayed.

This way you obtain the report you need.

Danut.

Trudy P Claspill

Hello @mr john

Welcome to the Atlassian community.

Please refer to the reply I provided for information on what is possible with native functionality.

Trudy P Claspill

Here is an example of what is available with only Jira native functionality for output of an issue and the issues linked to it, via the Search Work Items feature.

Screenshot 2026-03-14 at 12.32.50 PM.png

The main item (CS-252) and each item linked to it are displayed as separate rows in the JQL results output. You can add more columns to the results display to see additional fields' data for each item.

Raj Reddy_zu1v5p

Thank you very much. I guess the answer is no.

It is interesting, Jira has all the data, and we are struggling to find an answer - a way to present it.

Trudy P Claspill

It is interesting, Jira has all the data, and we are struggling to find an answer - a way to present it.

@Raj Reddy

Unfortunately with only native Jira functionality it is not possible to present the information. That will require a third party app of development of your own custom solution.

Raj Reddy_zu1v5p

Understood. Thank you.

Martins Vanags_eazyBI

Hi @Raj Reddy

This is Martins from the eazyBI team.

If you are considering 3rd-party apps in Jira, in eazyBI you can pull details for linked work items and display them in reports.

You could check this public demo report example: https://eazybi.com/accounts/22010/cubes/Issues/reports/376216-stories-with-bugs-details

In that report, you can see stories and their linked work items with type "Bug" that are linked with a specific link (which you can specify for eazyBI).

And not just see them as a CSV list, but also calculate their work log hours.

Martins / eazyBI

Welcome!

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

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud