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.

[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

[Raj Reddy]

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. 

[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.

See also this article: https://community.atlassian.com/forums/App-Central-articles/How-to-Visualize-Linked-Issues-and-Their-Status-in-Jira/ba-p/3150240

Danut. 

[mr john]

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?

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

[Trudy 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.

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.

[Trudy 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]

Understood. Thank you.