Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Announcing the waitlist for Jira Work Management

Hey there Cloud Community members! We’re excited to give you the first glimpse of the new home for business teams on Jira — Jira Work Management. Jira Work Management is the next generation of J...

750 views 12 19
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