I need to put a time limit on columns in Jira. I have a way to put a limit on the amount of issues in the columns but I need a time limit so it is easily shown if I am using more than 1 day on an issue.
It can also be solved by creating a quick filter showing the issues where the time in source status (under transitions) is more than 1 day. However I cannot find the right JQL for this.
Any solutions to this?
There's no method to set the column based on time - so to turn a column red if the issue has been in that column more than 4 hours.
But there's an alternative I've seen used before using Card Colours:
If you have multiple SLAs depending on the status you'll need to create multiple time-based filters and multiple card colour JQLs - if it's all just 4h per status, you could be as simple as: filter != XXXXX
Another option I've seen work well is to have different colours to show if it's approaching an SLA - eg:
You could achieve these with more history searching - see this article for some great information on this!
I will see if I can explain it differently
It is possible to put column constraints on a columns, so fx it is only allowed to have 10 issues in one column, and if there is more, it turns read.
I need some way to do this but with time, so if issues are in a column longer than fx 4 hours, the column or the specifik issues turns read.
OR, I need to know th JQL to just filter out all the issues that has been in the same column for more than four hours. I thought the JQL would be something like timeinsourcestatus<4h, but that is not possible to choose
Does it make more sense now? :)