9

I'm trying to use the "Card colors" feature of JIRA Agile, plus the ScriptRunner plugin, to color blocked cards on a JIRA agile board.

My definition of "blocked" is: ticket has a value for the "Blocked" field or is linked to an unresolved ticket in a "is blocked by" relationship.

The best I can do is the following JQL:

(Blocked is not EMPTY) OR issueFunction in hasLinks("is blocked by")

This finds tickets that have a value for the "Blocked" field, and tickets that are linked to another ticket in a "is blocked by" relationship, but it will still color the card if all linked blockers are resolved.

Is there any way to only find tickets linked to unresolved blockers?

I looked in the ScriptRunner docs but couldn't find anything.

nico gawenda
  • 3,648
  • 3
  • 25
  • 38
yolfer
  • 95
  • 1
  • 8

1 Answers1

3

You can do this the other way around: Find all linked issues that are marked as being a blocker and have no resolution set.

Example to find all unresolved tickets with unresolved blockers:

issueFunction in linkedIssuesOf("resolution is EMPTY", "blocks") and resolution is EMPTY
nico gawenda
  • 3,648
  • 3
  • 25
  • 38
  • 2
    Update: I changed the JQL slightly to also trigger when the "Blocked" field has a value: `Blocked is not empty OR (issueFunction in linkedIssuesOf("resolution is EMPTY", "blocks") and resolution is EMPTY)` – yolfer Jan 04 '16 at 23:47
  • 4
    FYI, this solution requires a paid subscription for the ScriptRunner plugin. It's insane that Jira does not have the ability to search for these issues with native JQL. – Justin Aug 09 '17 at 19:41
  • Isn't it possible to install the latest unpaid version? IIRC it had that, too. – nico gawenda Aug 10 '17 at 11:52