Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do I filter issues that are blocked in JQL

Edited

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:

https://community.atlassian.com/t5/Jira-Software-questions/JQL-for-issueLinkType-quot-blocks-quot/qaq-p/1232889

https://jira.atlassian.com/browse/JSWCLOUD-20736

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.

Andy

Thanks Andy, I'll give that a try

0 votes
Muhammad Ramzan Community Leader Sep 16, 2019

@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

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
TAGS
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

65 views 0 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you