I am trying to write a JQL query to filter blocking issues for a specific project. So far I have:
project = "Project Name" AND issuelinktype = blocks
However, the results show both blocking issues and issues that are "blocked by". I would like the filter to only show the blocking issues and exclude the "blocked by" issues. Any advice?
Hey @Ammaar Ahmed
please have a look at your issue link configuration. By default, the issue link type "blocks" has the name/description "blocks" and the outward description "blocks". I'm pretty confident that the JQL function looks at the description value as well. So try a different name for it. I tried this once but also had to recreate some issue links. Indexing seemed a bit off but after that I really only got the right results returned.
Please let us know if that solved your problem. :)
makes sense to me and I just tried to explain to you why you get the wrong results returned with your JQL filter. Do you notice the "Name" and "Outward Description"? That's causing the behaviour and feel free to change the configuration to fix it for you. :)
Thanks @Max Foerster - Decadis AG ,
The fix worked! Now I have set up some JQL queries on the board to indicate colors for the issues that are blocking (red) and the issues that are blocked by (blue), for better visual management. I am almost there, the only thing I am trying to figure out is I want the color for a "blocked by" issue to go away when the corresponding blocking issue is resolved. Any suggestions on JQL for this? Right now I have:
project = "Business Intelligence " AND statusCategory != Done AND issuelinktype = "is blocked by"
I am on Jira Cloud.
What we use to identify blocker links is the following:
issueFunction in linkedIssuesOf("key in (JIRAKEY-XXXX) and status not in (closed, done)") and project = "PROJECT ID" and issuetype in (bug,incident) AND status not in (closed,Done) AND issueFunction in hasLinks("blocks")
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