Forum Discussion
How can I pull the date of when a ticket was moved to a In Progress status?
Hello All, azure I am trying to pull the date when the ticket is moved from ToDo to In Progress Status using queries. What i tried ? > Tried all the Colum options available in the query but ...
To pull the date when a ticket is moved from "ToDo" to "In Progress" status, you can use the "Was Ever" operator in your query. Here's a sample query to achieve this:
Work Item Type In Task, Bug, User Story
AND State Was Ever In ToDo
AND State = In Progress
This query will show work items that were once in "ToDo" state and are currently in "In Progress." It should help you track when the transition occurred. If this doesn't work, double-check your work item states and ensure they are correctly set up in your project.
Thanks Robina for your prompt response, appreciate !!
I was able to run the query suggested one, and i am getting the tickets but not the date (Date when ticket is marked in progress) when the ticket moved from ToDo(New) to In Progress..
Any help here pls.
Tried below, but not sure why those col. are empty.
