Color code cards

[jdreizler]

Can someone please help me with the JQL for coloring a card:

Green if the create date was today or yesterday, or 2 days old.

Yellow if the create date was 3-4 days ago

Red if the create date was 5+ days ago

I dont care about change in status as i do about how long the issue has been out there.

THANKS!

[Joshua Sneed Contegix · Accepted solution]

Hi jdreizler,

I've doen these from memory and know that I did not capitalize as expected, but they should be fairly close to what you need.

Green: created >= startofday(-2)
Yellow: created = startofday(-3) OR created = startofday(-4)
Red: created = startofday <= (-5)

Cheers!

[Joshua Sneed Contegix]

:doh:

Red: created <= startofday(-5)

That's what I get for trying to think before my brain agrees to work. Cheers!

[Sylwia Wi]

Does anyone know if there is any limition in JQL field in Card colour section? I have a quite long query (488 characters) and in this case JIRA doesn't accept it - it means doing nothing: no error message, JQL field remains active, function buttons are in edit mode. 

[Gerry Bolger]

Is it possible to due it based on due date

1 days before due date = yellow

Due date = orange

Overdue (past due date due date +1 red

Thanks in advance

Gerry

[John Funk]

Hi Gerry - Yes, simply change out the word created above for duedate.

Then adjust the times as needed. 

One other note - it is always best to create a new question in the Community so everyone will see it. If you post to existing questions, typically it is only the people involved in the threads will see it. 

[Gerry Bolger]

Thank you both for the answer and also the etitique tip as well.

[John Funk]

Hi @jdreizler ,

Try this for the JQL

Green - Created >= startOfDay(-2)

Yellow - Created >= startOfDay(-4) and Created <= startOfDay(-2)

Red - Created <= startOfDay(-5)

You might have to adjust your dates a little. And you probably don't need that second part for Yellow if you have Green as the top color (above Yellow)

[jdreizler]

Thanks everyone these worked!!!

[jdreizler]

I tried to exclude anything that is closed and it failed i tried this:

Created >= startOfDay(-2) and status = Open

CAn you tell me why that didnt work...thanks

[John Funk]

What do you mean by it "failed"?

Maybe try statusCategory != Done instead of status = Open