Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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!

3 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!

0 votes
John Funk Community Leader Oct 13, 2020

Hi @jdreizler_forwardair_com ,

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

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

Suggest an answer

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

Product feedback on Inline Comments

Hello Community members! We have an upcoming research study for Confluence and we’d like to invite you to provide advice and answer questions. We’re developing a new experience for Inline Comment...

89 views 7 5
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