It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

filter based on days in workflow

I am trying to setup a filter in the Kanban view, based on the number of days an issue has been in a specific workflow status.  I have setup a workflow where an issue will move from "Backlog" to "Planning".  I would like to know if the issue has been in Planning for more than 3 weeks.  I know you can turn on the "Days in Column" feature, and hover the dots on the Card to see the actual number of days, but I'm looking for something better.

1 answer

0 votes
Jack Community Leader Nov 21, 2019

try this. i haven't tried so some tweaking may be required

status = "Planning" and status was in "Backlog" BEFORE startOfDay(-15d)

now what the above does not take into consideration is the case where the issue was in the backlog and then moved to planning and then moved back to backlog and then moved back to planning. but that is a corner case.

Thanks Jack.

I settled on:

status changed FROM "Backlog" TO "Planning" BEFORE "-20d" AND status = "Planning"


Had to use “20d” instead of “3w” to see issues that were 21 days and older.

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you