JQL filter for "Days in column"?

Question

Hi there,

I have a Kanban board where I can see this grey/red dots, showing me the number of days this issue is in that column/status. The question is, if I can filter on that value with JQL.

I known I can use a filter like 'status = "In progress" AND NOT status changed after -5d', but this is not the same, as it only takes into account the time when it last got this status, not the overall time in this status.

Thanks in advance, Markus

Markus · Answer

Thanks for your answer.

As you can see in my question, this is what I already use, but when transition to a different status and then back again, the vlaue is reset.

Looks like it is not possible with the standard feature set in JIRA :(

Jonas Bang Christensen · Answer

Based on the solution in this topic I have created a Quick Filter to show "issues in same column for x days".

Simply add this into the JQL:

NOT status changed after -5d

Or:

NOT status changed after -1w

I also hide issues in "backlog" columns for this Quick Filter as issues are allowed to stay in same column for a long time, so:

NOT status changed after -5d AND status not in ("In Refinement", "Approved Backlog", "Done")

Not sure if this is what you were looking for. To my knowledge you do not have access to "days in column" in JQL.