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 of issue or column if not changed in XXX days

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

2 answers

2 votes

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

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...Screen Shot 2020-01-03 at 8.46.28 PM.png

@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 

Suggest an answer

Log in or Sign up to answer
TAGS

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