Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How do I filter issues that are blocked in JQL


Hi All, I'm trying to write a JQL filter to only show me issues in a project that block other issues however when I run the query ...

project = XX AND resolution = Unresolved AND Flagged = Impediment AND issueLinkType = "blocks" ORDER BY priority DESC

...I also get issues back that are not blockers, but are blocked by other issues. Can anyone explain why?

4 answers

1 accepted

1 vote
Answer accepted

The problem is that issueLinkType supports both inward/outward directional names (blocks, is blocked by) and the link type name (Blocks).  This is a problem because JQL is not case sensitive.  So if you want to search for "blocks" and not "is blocked by", you can't do that.  This is a serious limitation because you can't rename the Blocks link type in Jira Cloud, Jira will just make a new Blocks link type and you will have two directional link type options of blocks/is blocked by in Jira.

See also:

0 votes
Andy Heinzer Atlassian Team Oct 07, 2019

Hi Chris,

I think I understand the confusion here.  The issueLinkType is a relatively new JQL function, only available since Jira 8.0.0.  This will return to us any issue that has a link of that type.  However it does not tell us anything more about the linked issue itself.

The only reason I can think of as to why you might get JQL results for this query that do not appear to actually have a 'blocks' type link, is that your account in Jira does not have permissions to see the issue that this issue is linked to. 

When that happens, your account won't see the link itself, but the issue still does have at least one link of that type to another issue.  This could be as simple as lacking the Browse permission in that other project, or it could be more complex and be restricted by a security scheme, in which case you might have the project permissions, but lack the security level needed to see that linked issue.  Either way, it is possible that your JQL query can return issues that appear to you to have no such links of that type.

As for how you figure out what that issue might be, well that gets harder to do.  If you are not a Jira admin, I would recommend reaching out to your Jira admin to see if perhaps they get back some more details about the link type on that issue.  Then again, they might not want to reveal that data to you, but they could likely confirm that this is the situation at least.

I hope that helps to explain this behavior.  Please let me know if you have any concerns about this.


Thanks Andy, I'll give that a try

0 votes

@chris I tested your query and it worked fine and only returned those issues which blocking other issues. 


Try to index your jira 

Strange, I'm trying to think what could be different about my setup

0 votes

You can use something like this

project = XX and resolution = Unresolved AND Flagged = Impediment and issueFunction in hasLinks(blocks)

Thanks, does this solution work without ScriptRunner though? I was hoping to avoid using it

Unfortunately this exact syntax is applicable only for SR

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events