nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I create a filter using days in column?

Tony Wahmhoff

The Greenhopper cards show how many days the card has been in its current column. I would like to create a filter that show all issues that have been in a column for more than 5 days. It seems this would be possible since the cards show the data I would need to calculate on.

The business reason behind this is to create a focused list for a weekly management meeting to review "exception" issues that might need some management attention. This would be easier than hovering over every card in a complex board with a large number of cards.

Accepted answers

Tony Wahmhoff

There does not appear to be a good way to accomplish this.

All comments

Tanner Wortham

You might consider using the 'Updated Date' field to your advantage. See the screenshot below. Bear in mind that comments to issues change the updated date.

Tony Wahmhoff

There does not appear to be a good way to accomplish this.

Dave Clay

+1 I need a daily standup meeting dashboard to quickly look and see who's on what during the sprint. I want to drive that discussion by showing any cards that are sitting in a column for more than some number of days. That data has to be in

Brandon Gill

+1 Agreed. It would be super helpful to be able to setup a quick filter that showed tickets that have spent a long time in a column. I like the dots along the bottom, but it's hard to quickly scroll through larger boards and see which are the aging ones.

unknown

There is one solution, but you have to define it for every column:

JQL:

status = "In Progress" AND status changed to "In Progress" before "-5d"

unknown

@Dave Clay & @Brandon Gill have a look at my answer below (https://answers.atlassian.com/questions/144207/answers/46082054)

unknown

Oh, you can even do it generally for all columns:

status CHANGED BEFORE "-5d"

Joe McAlear

Status changed before -5d and not status changed after -5d

BenLeggiero

New link: https://community.atlassian.com/t5/Jira-questions/Re-How-can-I-create-a-filter-using-days-in-column/qaq-p/228938/comment-id/95242#M95242

Michael Ellis

status = "In Progress" and not status changed during (-5, now())

Michael Ellis

This should not be the accepted answer. Alexander Shocke gave a good answer below.

I would suggest using During though. If you use Not Changed DURING(-5d,now()) you select issues that have not left the column. Before will show anything that moved to WIP before that, even if it left the column and returned to WIP.

JQL:

status = "In Progress" AND status changed to "In Progress" before "-5d"

Ville Lavikka

Days in this columns and days since last status change are different things. First does not reset when the card goes to another status and comes back.

Julio_Cortes

Hello I need that when I export the information to Excel I can have a column with the value of the days that a card has been in a column. It's possible? How could I do it or what syntax could I use? Tks

Julio_Cortes

Hello Ben I need that when I export the information to Excel I can have a column with the value of the days that a card has been in a column. It's possible? How could I do it or what syntax could I use? Tks

BenLeggiero

@Julio_Cortes That question is related to this one, but is a completely different question. Please ask it as a separate question.

Ricardo Antunes

Hello! I need to do that too. Did you get any solution? Thanks!

trisha singla

Hello! I need to do that too. Did you get any solution? Thanks!

John Corwith

Lots of people want this but it is not included in Jira. May be available in a plug-in.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-cloud