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?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Custom card color based on duedate with "between date"

Jonathan Van Be

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?

Accepted answers

MichałS

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

All comments

MichałS

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

Jonathan Van Be

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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud