JQL to filter blocked issues

[Alex Hadden-Boyd]

I'm trying to run a query in Jira Cloud that returns all bugs that are not closed (that part works) except for those bugs that are blocked for some reason.  I've tried using the IssueLinkType not in("is blocked by") in various combinations and I can't seem to get it right.  I think it's a question of OR vs AND or placement of parentheses.

"Delivery Area/Team" = Telephony AND issuetype in (Bug, "Classic Bug") AND status not in (Closed, Done, Complete, Cancelled, Completed) and issueLinkType not in("is blocked by")

[Ste Wright · Accepted solution]

Hi @Alex Hadden-Boyd 

Try:

"Delivery Area/Team" = Telephony AND issuetype in (Bug, "Classic Bug") AND status not in (Closed, Done, Complete, Cancelled, Completed) and (issueLinkType != "is blocked by" or issueLinkType IS EMPTY)

When you search for "!=" or "not in", Jira will attempt to return issues with another link type - but NULL is not counted as another link type. So you need to add the additional search to look for those which are empty also.

Additionally, if those closed statuses are all your "done" statuses you could shorten the above utilising statusCategory:

"Delivery Area/Team" = Telephony AND issuetype in (Bug, "Classic Bug") AND statusCategory != Done and (issueLinkType != "is blocked by" or issueLinkType IS EMPTY)

Ste