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!
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
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:
Hope this helps you to create awesome queries <3
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