Rally Software

  • 1.  Attempting to query for Status Dates

    Posted Sep 25, 2018 11:38 AM

    Is there a way to track the date each user story, defect, and/or task has moved to a different status? I'm not sure if Rally saves the date an item was moved from a "Defined" status to "In-Progress". Using the "Last Updated" field is not accurate so I'm trying to find a way to determine how much time is spent between statuses.

     

    Thanks,

    Blake



  • 2.  Re: Attempting to query for Status Dates

    Posted Sep 25, 2018 02:36 PM

    Hi Blake - There are likely multiple ways to do this. I can tell you that state changes, such as from "Defined" to "In-Progress", are tracked as I've seen them in Revision History of work items.

    Possibly the info @ https://docs.ca.com/en-us/ca-agile-central/saas/viewing-rally-revision-history and/or https://docs.ca.com/en-us/ca-agile-central/saas/build-app-queries-new can help you out.



  • 3.  Re: Attempting to query for Status Dates
    Best Answer

    Broadcom Employee
    Posted Sep 25, 2018 02:39 PM

    Hello Blake,

     

    The following help article should help you with writing a query to get the Status dates.

     

    Agile Central - LookBack API: Get all Previous Sta - CA Knowledge 

     

    Please let us know if you have any questions.

     

    Thank you,

     

    Christian 



  • 4.  Re: Attempting to query for Status Dates

    Posted Sep 25, 2018 02:49 PM

    I'm not really familiar with Lookback but it seems to provide the answers that I need. Is this something that I need to have installed? Looking through the documentation it really doesn't seem to have a how to manual of getting started.



  • 5.  Re: Attempting to query for Status Dates

    Broadcom Employee
    Posted Sep 25, 2018 04:13 PM

    Hi Blake,

     

    You don't need to install the Lookback API. Here is the documentation: https://rally1.rallydev.com/analytics/doc/#/manual 

     

    We do have a Java tool-kit for it too, see: GitHub - RallyTools/Rally-Lookback-Toolkit: Toolkit for interacting with the Rally Lookback API 

     

    But you don't have to use Java. The article that Christian shared basically shows how to construct the query in Postman against the REST endpoint itself.

     

    Let us know if more, specific, questions.

     

    Sagi



  • 6.  Re: Attempting to query for Status Dates

    Broadcom Employee
    Posted Sep 27, 2018 12:36 PM

    Hello Blake,

     

    LBAPI is the way to get time series data for changes to a work item, and if you need to do math on the dates of changes - such as calculating 'time in state' for various workflow states - that is probably what you need. However, you can see the In-Progress Date and the Accepted Date for a User Story just by adding those columns/fields to a list view like the Custom List App configured for User Story.