JQL for all linked issues not done

Question

HI,

I want to have a query that indicates when all the linked 'is blocked by' issues are not Done.  I want to use this in the Card Colors settings on a board so that I know if an issue is blocked by something else.  When all the 'is blocked by' issues are Done, I should not see that color anymore.

I have been trying to use ScriptRunner to accomplish this, but in the ScriptRunner Enhanced search, when I use a query like:

issuekey = <issue key> and issueFunction in linkedIssuesOf("status != Done", "is blocked by") AND resolution IS EMPTY

I get the following error:

Search parsing timed out. You probably have a subquery that returns too many issues.

I don't understand why that would happen for a specific issue where it only had 2 'is blocked by' issues linked to it.

Also, if I do get this to work, can I put the resulting query in the JQL field of the Card Colors?  Would it pick up ScriptRunner syntax?

Thanks in advance for your help.

Peter Retzlaff · Answer

Hi @Norton Lam ,

I tried to achieve exactly the same thing today :)The query I used to find all issues that were still blocked by other issues is this:

sprint in openSprints() AND issueFunction IN linkedIssuesOf("sprint in openSprints() AND status != Done", "blocks") order by created DESC

As previously stated, you can then save that as a filter and use the "filter = <filter name>" query as your card color query.

This works well for me, although the automatic filter sync doesn't work for me right now, so it's not actually useful right now. However, that's a different problem ;)

Italo Qualisoni [e-Core] · Answer

Good to know that the JQL worked.

It's not possible to use field substitution in your JQL query.

You can pass the same query in your board, something like this:

issueFunction in linkedIssuesOf("project = XYZ and status != Done", "is blocked by") and status != Done AND resolution IS EMPTY

You will need to test and see what works for you. I think you can also reach Adaptavist support to ask for guidance to improve your JQL filter.

Norton Lam · Answer

Thank you, @Italo Qualisoni [e-Core] .  You partially answered my question.

Your query worked, but in the Card Color, it does the query based on the issue it is trying to show.  My query above would have eventually removed the clause before the first AND in order to show the correct result.  In your query, since the issuekey is being saved in the filter, it won't work.  Unless you know of a way that the system would do a field substitution.

Or, if I could pass the key in as a parameter, I could use the filter in a ScriptListener script.