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

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
Joshua Sneed Contegix
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.
Oct 13, 2020

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
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.
Oct 13, 2020

: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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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
AUG Leaders

Atlassian Community Events