Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
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

Color coding cards based on weeks

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?

1 answer

1 accepted

0 votes
Answer accepted
John Funk Community Leader Oct 30, 2020

Hi Samuel,

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:

https://confluence.atlassian.com/jirasoftwareserver/customizing-cards-938845307.html#:~:text=You%20can%20base%20your%20card,%2C%20then%20click%20Board%20%3E%20Configure.

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?

John Funk Community Leader Oct 30, 2020

duedate <= endOfDay(2w) Red

duedate <= endOfDay(3w) Yellow

duedate >startOfDay(3w)   Green

Make sure the colors are in order from top down like above

Thank you for your help John! That seems to be working correctly now.

Like John Funk likes this
John Funk Community Leader Oct 30, 2020

Great! Glad I could help. 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

321 views 9 7
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