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 ...

azure devops

Flow State

expertopinionsa12

Copper Contributor

Oct 16, 2023

Hi Syed_az,

It seems like the date information might not be included in the current query. You can modify the query to include the "Changed Date" field. You can try..

Work Item Type In Task, Bug, User Story
AND State Was Ever In ToDo
AND State = In Progress
ORDER BY Changed Date DESC

If this still doesn't solve the issue, there might be a possibility that the date information is not captured in the system for these transitions. In that case, you may need to check the configuration of your work item states or consult your Azure DevOps administrator to ensure that the necessary fields are being tracked. I usually take help from triotech systems devOps team. They really manage things well.

Feel free to give this a try, and if you encounter any further issues or have additional details to share, I'll be here to assist.

Thanks!

Syed_az

Copper Contributor

Oct 17, 2023

Thank you, but no luck !!

Robina
MCT
Oct 17, 2023
Syed_az
To track the date of transition, use the "Was Ever" operator in your query.
Work Item Type In Task, Bug, User Story AND State Was Ever In ToDo AND State = In Progress
This query should show work items that were once in "ToDo" state and are currently in "In Progress."

Forum Discussion

How can I pull the date of when a ticket was moved to a In Progress status?

Resources