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 to conditionally show issues based on status of each Linked Issue?

Michael Taylor_nrblee

I want to build a report in Confluence by showing all tickets from a project. Let's call this project X. However, I only want to show cards from project X where all linked issues to that card have a status of closed.

For example, issue A will have 3 linked issues. If any of those linked issues does not have a Closed status, then issue A will not appear in my report.

If issue B also has 3 linked issues, but all are closed, then issue B will show up in my report.

I do not have access to any external plugins so I have to do this only with native jql. Is this possible?

I essentially need to get all issues from a project then check the status of each linked issue.

Any help would be greatly appreciated!

Accepted answers

Lenin Raj

Hi @Michael Taylor

In the native out of the box JQL solution, we can only filter on the "type" of the linked issue. See https://confluence.atlassian.com/jirasoftwareserver073/advanced-searching-functions-reference-861256240.html#Advancedsearching-functionsreference-linkedIssueslinkedIssues() for more details.

What you have described (filtering based on the status of the linked issue) is only possible using an addon.

For server, please see https://marketplace.atlassian.com/apps/1218367/jql-booster-pack?hosting=server&tab=overview

For cloud, please see https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira-reports?hosting=cloud&tab=overview

All comments

Lenin Raj

Hi @Michael Taylor

What you have described (filtering based on the status of the linked issue) is only possible using an addon.

For server, please see https://marketplace.atlassian.com/apps/1218367/jql-booster-pack?hosting=server&tab=overview

For cloud, please see https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira-reports?hosting=cloud&tab=overview

Michael Taylor_nrblee

Hi, @Lenin Raj

I appreciate the speedy reply. I will have to speak our team to see if we're willing to upgrade to the appropriate addon.

Jira is a great platform and very powerful. It would be great if this functionality was available in the native JQL.

Jack Nolddor [Sweet Bananas]

Hi Michael,

In addition to Lenin native functionality... if you really want to query de linked status and not only the link type, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

Search for issues in wich all their linked issue are in the Closed status

issue IN linkedIssuesOf("status = Closed") AND issue NOT IN linkedIssuesOf("status != Closed")

Using this app you can also query other issues relations, check:

References:

Official documentation

Hope this helps you to create awesome queries

Kind regards

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql

issue-link