It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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! 

2 answers

1 accepted

1 vote
Answer accepted

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

Hi, @Lenin_Raj_Rajasekaran 

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. 

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:

 

Hope this helps you to create awesome queries <3

Kind regards

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you