Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,161
Community Members
 
Community Events
165
Community Groups

Color code cards

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!

4 answers

1 accepted

0 votes
Answer accepted

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!

:doh:

Red: created <= startofday(-5)

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

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. 

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 M Funk Community Leader Dec 11, 2020

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. 

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

Like John M Funk likes this
0 votes
John M Funk Community Leader Oct 13, 2020

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)

Thanks everyone these worked!!!

Like John M Funk likes this

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 M Funk Community Leader Oct 14, 2020

What do you mean by it "failed"?

Maybe try statusCategory != Done instead of status = Open

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

159 views 1 3
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you