JQL filter for "Days in column"?

Markus November 16, 2023

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

1 answer

0 votes
Jonas Bang Christensen January 31, 2024

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. 

Markus January 31, 2024

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 :(

Like Jonas Bang Christensen likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events