Query for time ticket has been in sprint

[robert_whitelaw]

Howdy Folks,

We are currently doing a kanban - non-sprint - method for handling tickets. We have a sprint called "Intake" and and a sprint called "Reviewed and ready" - which do not have start or end dates. Tickets are created in intake and sit there until they are fully actionable. The reason for this relates to contracts, third parties and general cat wrangling - but it 'works'.

Once something is ready for actual work to happen, it goes into "Reviewed and ready" where a variety of priorities are applied to determine what work gets done first. What I want to do is to be able to determine card colors in the kanban flow by how long a ticket has been in the sprint titled "Reviewed and Ready" - NOT how long since the ticket was created (Which could be months depending on how long it took to get all approvals while the ticket was in 'Intake'). I have tried a variety of queries to accomplish this with no luck.

Any help appreciated!

Cheers,

R

[Muhammad Ramzan(Atlassian Certified Master)]

You want to get records only or card colors

[robert_whitelaw]

So I was shooting for card colors. However, I think that after looking at this for a while, it might be easier/better to simply create a status for when my tickets are in "Intake". Then when they are ready, change them to "ToDo" and key off of the status change instead of the sprint change. My end goal is to be be able to view all the tasks in the kanban view and have the color of the card indicate how long it has been in reviewed and ready - which I can kinda get with the status plan. Not sure what would happen if it got moved to blocked then back to todo. Would it reset the time in status returned value?