How to search for issues that all linked issues are resolved Edited

Hi, 

Is there a JQL that allows you to return all issues in a project for which linked issues have status = Resolved. If one of the linked issue status is not resolved, I don't want it to be returned by JQL query. 

Thanks.

 

1 answer

1 vote
Alex Christensen Community Champion Apr 27, 2017

If you're on Server and have ScriptRunner installed, you can use this JQL or something similar. Note that this JQL returns issues which have at least ONE linked issue which has a status of Resolved - this does not check for all linked issues.

issueFunction in linkedIssuesOf("status = Resolved")

To my knowledge, this isn't possible out of the box.

Hi Alex,

I have ScriptRunner installed but am struggling with the query that returns issues where ALL linked issues are resolved. Any ideas on how to achieve this?

Thanks,

best regards,

Kevin.  

@Alex Christensen - wouldnt your query pick parent issues where the children are resolved? I dont  think thats what Kevin wants. I am in the same boat. Trying to identify parents with dependencies. But want to restrict the linked issues that are displayed to ONLY those aren't resolved.

Alex Christensen Community Champion Mar 06, 2018

@Kevin Dekan @Pradeep Nair - what about something like this query?

issueFunction in linkedIssuesOf("resolution != Unresolved") and issueFunction not in linkedIssuesOf("resolution = Unresolved")

In my testing, I was able to get a list of issues in which all linked issues were resolved.

Hi @Alex Christensen,

your query works great, thanks for your help!

Best regards,

Kevin. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 25, 2018 in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

463 views 7 5
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you