Filter to find issues with links to other issues which are unresolved

I'm trying to use JQL, and Script Runner functions, to construct filters which give me a list of issues (typically stories) in a project which have a link (or links) to other issues where the linked issues are unresolved.

It's the last bit I'm struggling with. I can get the list of stories which have links easily enough with:

project = KBP AND issuetype = Story AND issueFunction in hasLinks("is blocked by")

but this shows me all stories which have that link relationship irrespective of whether or not the linked issue has been resolved.

And, of course, adding

AND resolution = Unresolved

simply selects the unresolved issues in the returned filter, rather than the issues with unresolved *linked* issues.

Any advice?

1 answer

1 accepted

0 votes
Thomas Schlegel Community Champion Feb 16, 2017

Hi Kevin,

this should do it:

project = KBP and issuetype = Story AND issueFunction in linkedIssuesOf("resolution = unresolved", "blocks")

Thomas

Thomas, thanks. Your query wasn't quite right but gave me enough to find the solution.

The link relationship I needed was "blocks", because in my project the linked issues block completion of the stories (rather than the other way around). Thus:

project = KBP and issuetype = Story AND issueFunction in linkedIssuesOf("resolution = unresolved", "blocks")

to find the stories which have linked issues which are unresolved. smile

Of course, I can now also create a filter which finds the stories which are no longer blocked by linked issues:

project = KBP and issuetype = Story AND issueFunction in linkedIssuesOf("resolution != unresolved", "blocks")

Thanks for the help.

Thomas Schlegel Community Champion Feb 16, 2017

you're welcome smile

Slight issue with the second filter:

project = KBP and issuetype = Story AND issueFunction in linkedIssuesOf("resolution != unresolved", "blocks")

If there is more than one linked issue which is blocking and not all are resolved, then story is included in the filter results. That's not the behaviour I expected, or want.

I want it to only return stories for which ALL linked blocking issues have been resolved. Any ideas?

Okay, I resolved my problem by adding a clause to make this tortuous query...

project = KBP AND issuetype = Story AND resolution = Unresolved AND (issueFunction in linkedIssuesOf("resolution != unresolved", blocks) ) AND NOT (issueFunction in linkedIssuesOf("resolution = unresolved", blocks) )

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Feb 15, 2018 in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

1,108 views 6 19
Read article

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot