How do I get a list of un-resolved issues that are blocking tests?

[Mark Ingle]

I have the following JQL written but it is returning issues that were blocking tests but are now resolved.....to be more clear...the issues listed in "is blocked by" for each test include issues that are been resolved.  I need to exclude these

issuetype = Test AND project = "BSS-Cerillion UAT Testing" AND issueLinkType in ("is blocked by") AND status != Resolved

[Mark Ingle]

I was just informed by our administrator that ScriptRunner for JIRA has been installed....maybe that will help.  Ill start reviewing ScriptRunner syntax

[John Funk]

Hi Mark,

Try this: issuetype = Test AND project = "BSS-Cerillion UAT Testing" AND (issueLinkType in ("is blocked by") AND status != Resolved)

[Mark Ingle]

thanks for trying John....its still pulling linked issues that are resolved.

[John Funk]

Nic is correct - it is not checking the status of the linked issues with that JQL.

[Mark Ingle]

I agree....hard to get it there though

[Nic Brough -Adaptavist-]

The issueLinkType clause looks at the type of link, it does not consider the issue on the other end of the link.  Is that what you think is wrong with your results?  It's not looking at the other end of the link?

[Mark Ingle]

Possibly...its been so long since I have used JQL.  3 years.  It does appear that it is ignoring the status of the linked issue that is blocking the test.