nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ScriptRunner JQL Query to Find Linked Issues of "is blocked by" AND Linked Issues' Status != Done

Paul_sudl0c

Hi,

What would be a JQL query to find (linked issues of type "is blocked by") AND (linked issues with status != Done) for a particular issue?

Example:

Issue ABC-1 is blocked by ABC-10 with status Done, ABC-20 with status Backlog and ABC-30 with status "In Progress".

The query should return ABC-20 and ABC-30.

Accepted answers

Jack Nolddor [Sweet Bananas]

Hi Paul,

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 you can type the following:

Search for issues that blocks others issues OR linked issues with status != Done:

issue IN linkedIssuesOf("status != Done", "is blocked by")

Note that this is just an exaple, you must tune your query to fit your needs

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

References:

Official documentation

Hope this helps you to create awesome queries

Kind regards

All comments

Jack Nolddor [Sweet Bananas]

Hi Paul,

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 you can type the following:

Search for issues that blocks others issues OR linked issues with status != Done:

issue IN linkedIssuesOf("status != Done", "is blocked by")

Note that this is just an exaple, you must tune your query to fit your needs

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

References:

Official documentation

Hope this helps you to create awesome queries

Kind regards

Paul_sudl0c

Hi Jack,

I should've mention I have ScriptRunner.

I'd prefer to use JQL with ScriptRunner's JQL extentions instead of be forced to use SQL.

Thanks for you reply.

Jack Nolddor [Sweet Bananas]

Hi Paul,

You can use the query I provided before on Script Runner as well.

However, you must note that you must query the issueFunction field instead

Use this

issueFunction <span>IN</span> linkedIssuesOf(<span>"status != Done"</span>, <span>"is blocked by"</span>)

Regards

Paul_sudl0c

I tried a lot of times, after all it seems so easy, but wasn't able to get correct results.

I could get ALL issues' blockers but couldn't get ONLY blockers for ONLY 1 specific issue.

REgards,

Paul

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

scriptrunner

jira

jira-software

jira-software-server