Forum Discussion

Syed_az's avatar
Syed_az
Copper Contributor
Oct 13, 2023

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 no luck, please find the below screenshots for quick reference.

 

Appreciate if some one can help to resolve..

 

Thanks !!

 

 

 

azure devops
Flow State

6 Replies

  • Iryna_Komarnitska's avatar
    Iryna_Komarnitska
    Copper Contributor
    Oct 23, 2023
    For a more detailed analysis of state changes in Work items and how much time they spend in states, try using the Time in State for Azure DevOps extension https://marketplace.visualstudio.com/items?itemName=SaaSJet.tis-azure .

    Using Work Items Range or Time Range filters, you can check when exactly the state was changed.
  • expertopinionsa12's avatar
    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!

      • Robina's avatar
        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."

         

         

  • Robina's avatar
    Robina
    MCT
    Oct 13, 2023

    Syed_az 

     

    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.

    • Syed_az's avatar
      Syed_az
      Copper Contributor
      Oct 16, 2023

      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.

       

       

       

Resources