Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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,466,618
Community Members
 
Community Events
176
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 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 Funk likes this
0 votes
John 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 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 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

Atlassian Community Events