filter based on days in workflow

Question

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.

jsalmond · Answer

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.

Jack Brickey_h10pa4 · Answer

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.