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.
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)
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)
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.
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...
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