Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

JIRA JQL: coloring cards by blocked status

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.

like image 793
yolfer Avatar asked Aug 24 '15 21:08

yolfer


People also ask

Can you color code in Jira?

Just go to the board and select configure board and card color. On that page you should be able to select Issue Type. It appears you are on server.

When to use is blocked by in Jira?

1 accepted Issue A is blocked by issues B it means that until the status of issue B is not "Done" or the resolution of issue B is empty, Issue A can't transit and for blocks, it is visa versa. But consider that these are just labels and if you link issues to each other they don't prevent each other from transitioning.

How do you color tickets in Jira?

Select Active sprints(if you use a Scrum board) or Kanban board (if you use a Kanban board). Select More ( ) > Board settings. Click Card Colors and change the Colors based on drop-down as desired.


Video Answer


1 Answers

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
like image 83
nico gawenda Avatar answered Sep 30 '22 23:09

nico gawenda