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
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())
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'))
This show what the above does for my board...
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