How to conditionally show issues based on status of each Linked Issue?

[Michael Taylor]

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! 

[Lenin Raj · Accepted solution]

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

[Michael Taylor]

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:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

Hope this helps you to create awesome queries <3

Kind regards