Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Configuring Kanban Card Colors for Past Due Date


I am still new to writing syntax for JIRA. I would like to configure my Kanban board that when the Story card goes past due based on the due date, the card turns red. Not sure what I should use to do this and my attempts have failed. Can someone help? 


1 answer

1 accepted

1 vote
Answer accepted
Jack Brickey Community Leader Apr 29, 2019

Hi Jessica,

you can use one of the following JQLs. you may need to tweak a bit to match your statuses, etc. You Card Color by Queries and paste one in to get started. You can get fancy if you want and show red for past due, yellow for due w/in x-days, etc.

due <= now() AND status not in (done, closed, resolved)

due <= now() AND resolution is not EMPTY (note, if you are not religious about setting the Resolution when closing issues then this won't work)

This was great. Thank you!! 

Jack, thanks so much! I was able to adapt this to get my cards to change color if they are not updated on time! 

"Script Ready Date" <= now() AND status = "Staged"

So glad I found this post from 3 years ago, lol!

Suggest an answer

Log in or Sign up to answer

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