I want to create query that changes the card color from green to amber to red as per the due date.

[Anuradha Shet]

Our one sprint is 10 days. 

From 1st to 7th day, the card color must be green.

From 8th to 10th day, the card color must be amber (resembling, you must move your story so that you don't break threshold)

When it crosses 10th day (after last day of sprint), the card color must change to red, indicating, you broke the 10 day threshold and it needs attention.

[Jack Brickey · Accepted solution]

hi @Anuradha Shet , if you are using CMP projects then you can set the card color based upon queries. you could set the due date at the beginning of the sprint to be the end of sprint. Then write a JQL query based upon proximity to due date.

let me know if this does not make sense.