You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Hello, I am trying to color code our Jira cards to change colors based on the dates they are asking for. They are wanting to use the colors as warning indicators for due dates.
So this is what they are wanting for the card colors GREEN = >3 weeks from deadline, YELLOW = <3 weeks from deadline, and RED = <2 weeks from deadline. Can someone help with how I am supposed to write that our using the JQL?
I don't use Jira Server (just Cloud) but is there a way to do that in the issue layout from your board settings?
Go to Board Settings > Card Colors
In Cloud we can write JQL to match the color we have selected.
See if this helps you:
Thank you John, I have made it that far on my own. The part where I am stuck at is what do I need to put in the JQL for what timeframe they are looking for?
Right now I have the JQL set as duedate <= end of day () but I don't think it is working the right way. would you happen to know how I can set the JQL for the card colors GREEN = >3 weeks from deadline, YELLOW = <3 weeks from deadline, and RED = <2 weeks from deadline?
duedate <= endOfDay(2w) Red
duedate <= endOfDay(3w) Yellow
duedate >startOfDay(3w) Green
Make sure the colors are in order from top down like above