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.
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.
We’re excited to introduce external collaboration for Confluence, now available in early access. It is available to preview for Confluence Cloud Premium and Enterprise customers. (If you're not on ...
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