How to filter blocked issues in ScriptRunner Enhanced Search

[Algimantas Stancelis]

I want to filter all issues in a AA project that are blocked (have "is blocked by" link).

Problem:  ScriptRunner Enhanced Search does not have hasLinks() function. So hasLink("is blocked by") is not possible.

I've tried a couple options. None of which produce satisfactory result.

1. linkedIssuesOf() times out because it has to query a lot of possible blockers

project = AA linkedIssuesOf("project in (BB, CC, DD) and status != Done", "blocks")

We have a lot of projects and any issue in any project could block AA issue.

2. I can't find how to filter 'is blocked by' in issueFieldMatch()

 issueFunction in issueFieldMatch("project = AA and status != Done", "issuelinks", ".+")

Does anyone know how to get blocked issues in Script Runner Enhanced Search?

[Lucas Garcia · Accepted solution]

Try this instead

project = ABC AND hasLinks = "is blocked by"

[Algimantas Stancelis]

Nice! This one is exactly what I need.

[Ignacio Pulgar]

Have you tried this one?

project = AA AND issueFunction in hasLinks("is blocked by")

[Algimantas Stancelis]

As I've mentioned in my question, that is the problem I want to solve - ScriptRunner Enhanced Search does not have hasLinks() function. So hasLink("is blocked by") is not possible.

I'm looking for a workaround.

[Lucas Garcia]

I'm looking for this answer as well.

[Ignacio Pulgar]

Oh, sorry! Try this one instead:

project = AA AND issueFunction in linkedIssuesOf("status != Done", "blocks")

[Algimantas Stancelis]

Tried that as well.

1. linkedIssuesOf() times out because it has to query a lot of possible blockers

project = AA linkedIssuesOf("project in (BB, CC, DD) and status != Done", "blocks")