JQL filter for "Days in column"?

[Markus]

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

[Kaljan · Accepted solution]

Hi Markus,

Unfortunately, Jira Query Language (JQL) doesn't directly support filtering based on the total time an issue has spent in a specific status, including the grey/red dots on your Kanban board. The 'status changed after' clause focuses on the last status change, not the cumulative time. Consider exploring Jira add-ons or plugins that provide enhanced JQL functions or custom reporting capabilities for more advanced filtering based on time spent in a particular status.

Best regards, Kaljan Plaxyu

[Markus]

Thanks