Color of issue or column if not changed in XXX days

[Amit Dawani]

i need some help with below questions, the goal of these is to identify issues that needs attention (so that they stand out)

1. Change the In Progress column if there are issues in that column for more than 5 days

2. Change the color of issue in Jira board if they are in the same column for more than 5 days

is any of the above possible

[Earl McCutcheon]

Hello Amit,

For the Column Color there is not a customization option Blue Yellow and Green are the only three colors available depending on the position as covered in Configuring columns.

For Issues that have been in a certain column for a period of time, the Column is linked to a status and you can set the color based on the status for a period of time by going to board > Configure > card colors and select "colors based on queries" from drop down and use something like the following query to issues in the same status for more than 5 days:

NOT status changed AFTER "-5d"

You could also add in gradient of color using the following for one color to show everything that has been updated in the last 4 days and once it passes the 5 day mark would shift to the next color choice:

status changed DURING (startOfDay(-4d),endOfDay())

Please see Customizing cards for additional details on the card color options and Advanced searching - operators reference: CHANGED for details on the Query.

Regards,
Earl

[Dave Markowski]

This was exactly what I was looking for.  Thank you 

[Matthew Vetter]

I know this is old but for anyone running across this like I did I've been having issues with the above.

These seem to work for me. I also wanted it to ignore items in To Do or Done so added that as well. 

Anything Older than 2 Days

(status changed after '-3d' and NOT status changed after '-2d') AND (status NOT IN ('To Do','Done'))

Anything Older than 3 Days

(status changed after '-4d' and NOT status changed after '-3d') AND (status NOT IN ('To Do','Done')) 

Anything older than 4 days 

Couldn't do this like the others otherwise it trips up since we are looking for anything 4 Days +

(NOT status changed after '-4d') AND (status NOT IN ('To Do','Done')) 

Example:

This show what the above does for my board...

[Sebastien Pires]

@Matthew Vetter Can ask how you're colouring your cards? I can't find anything to color the whole card like in the screenshot you've attached