Custom card color based on duedate with "between date"

Jonathan Van Belle September 24, 2013

Hello,

I would like to configure an agile board (kanban view) in jira with some specific card colors based on JQL. I'm nearly the good configuration, but I don't find how to configure one

  • duedate is NULL OR duedate > "+3d" : green
  • duedate between 3d in the future and now : yellow
  • duedate = now() : orange
  • duedate < now() : red

the yellow one, i don't know how to make the query. Any idea?

2 answers

1 accepted

3 votes
Answer accepted
MichałS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 24, 2013

(duedate > now() AND duedate < "3d")

0 votes
Jonathan Van Belle September 24, 2013

I have tried but having some conflict, after another test with your solution I do the following change on the green one : 'duedate is NULL OR duedate > "3d"'
Now everything is ok.

MichałS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 24, 2013

JQL does not accept the "+" sign only the "-" is accepted. Its kind of strange but thats how it works :).

Suggest an answer

Log in or Sign up to answer