Find Issues where all "Depends On" issues are Done

Jonathan Mitchem_95j29e

I've found bits and pieces but haven't yet been able to put them together.

I would like to be able to query all issues that:

• have a "depends on" link
• where every linked "depends on" issue is Completed/Done/Resolved/Closed

 

The idea is to identify all tickets that can now be worked on, based on dependencies being completed.

Can this be done with JQL in stock Jira?  Can it be done with ScriptRunner?

Andrew Wolpers_2s8bej

Howdy Jonathan,

Using Scriptrunner, you could do something like: 

issuefunction in linkedIssuesOf("issueFunction in linkedIssuesOf('statusCategory = Done')","Relates To")

The first IssueFunction is looking for results of the `linkedIssuesOf` issuefunction, where we're ensuring everything is in a Done statusCategory that is using the `Relates To` link type. 

Here's Adaptavist's documentation with a heap of other examples of how you can use issuefunctions in your JQL: https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/issue-links 

Hope it helps!