filter out all blocked issues

[Ilia Tankelevich]

I would like to create a JQL query that shows all the issues with 'blocked by' linked issue and the blocking issue is not done

I can find all the blocked issues by issueLinkType = "is blocked by" , now how can I check the status of the linked issue?

[Jack Brickey · Accepted solution]

Hi Ilia, welcome to the Community. Hope this helps...

issuelinktype = "is blocked by" and status != done ... this will give you all issues in your instance that are linked to other issues with the "is blocked by" issue link type

issuelinktype = "blocks" and status != done ... this will give you all issues in your instance that are linked to other issues with the "blocks" issue link type

so let's say you have two issues...

ABC-123 and ABC-456

and...

ABC-123 is linked to ABC-456 as "is blocked by" then ABC-456 will be linked to ABC-123 as "blocks"

so you would choose the jql that best meets your goal

Finally, one thing to note is that you may be better off using "resolution is not empty" rather than "status != done" assuming you are indeed setting the resolution for all issues being moved to a Done category.

[Derek Fields _RightStar_]

I don't think that this will provide the answer that the OP needs. My reading is that he wants a list of all issues that are linked to another issue with "Blocked By" and the linked issue is not done. This is effectively a sub-query, which is not supported by Jira out of the box.

You would need ScriptRunner, which provides a function called linkedIssuesOf(Subquery, [link name]). This would let you write:

issueFunction in linkedIssuesOf("resolution is Empty", "Blocked By").

This would provide the list that OP wants

[Muhammad Ramzan_Atlassian Certified Master_ · Accepted solution]

As you are using jira cloud and currently the only possible way is sub queries which is not available naively.  There are some third party plugins like scriptrunner  and   JQL Search Extensions for Jira & reports

you can get your required results by using the plugin., let take example of JQL Search Extensions for Jira & reports. 

If you use this plugin you can create a sub query , for example name is : blockedissues

issueLinkType = "is blocked by"

 and then you can filter the results as below

issuesInQuery="blockedissues" and status=done

 it will get first all blocked issues and then filter them with status done.

Reference:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/3375124/JQL+Reference+Cloud#JQLReference(Cloud)-Subqueries

[Ilia Tankelevich]

thank you, everybody, for the answers

[Jack Nolddor _Sweet Bananas_]

H iIlia,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead, Using i.e. JQL Booster Pack  if you are on Server / DataCenter you can type the following:

1) Filter out all blocked issues where the blocking issue is not done

issue IN linkedIssuesOf(' resolution IS EMPTY ', 'blocks')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation