How to search for issues that all linked issues are resolved

[Louis-Michel Sirois]

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.

[Alex Christensen]

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.

[Kevin Dekan]

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.  

[Pradeep Nair]

@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]

@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.

[Kevin Dekan]

Hi @Alex Christensen,

your query works great, thanks for your help!

Best regards,

Kevin. 

[vashim shekh]

@Alex Christensen Thanks my condition will working.

I am very glad for your Answer..

"issueFunction in linkedIssuesOf("resolution != Unresolved") and issueFunction not in linkedIssuesOf("resolution = Unresolved") AND project = Agile_Test_Project AND issuetype = Feature"

Thanks 

vashim shekh

8452012430

INDIAN

[Sebastian Knychas]

Hi,

Can i ask for explanation of this query:

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

i used it for complex project structure where i have 3 projects and still can not understand the logic.

i wanted to list all items only from my project, that are not done but its parent (from other project) is done.

let say parent is from project A and i have linked as child epic from my project B.

item from project A is DONE but my subitem in NOT. i want to collet all such unresolved items from my projet.

[ADyPo]

Hi,

Oddly enough,  it seems that "issueFunction not in linkedIssuesOf" doesn't work anymore. I had to change it to "not issueFunction in linkedIssuesOf". Full JQL : 

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

It's minor but it can be confusing for newbies :-).

Thanks a lot for this query @Alex Christensen

Regards,

Dylan 

[Jose Antonio Uribe]

To contribute to the thread, if the resolution contains an apostrophe you can escape it like this:

linkedIssuesOf("status = Closed and resolution = \"Won't Do\"")