Date Completed Column for exporting to CSV/Excel?

5 posts, 0 answers
  1. Thomas
    Thomas avatar
    6 posts
    Member since:
    Aug 2010

    Posted 26 Aug 2010 Link to this post

    Is there a way to show the date a story was marked as completed in the grid?  I'm exporting to excel so I can do some analysis on the project, but without a completed date, I'm very limited.  Is there any way to get the completed date to export?
  2. Joel
    Admin
    Joel avatar
    300 posts

    Posted 27 Aug 2010 Link to this post

    Hi Thomas,

    That type of information is available in our database, but unfortunately there's no easy way to view it in a grid in TeamPulse.  We keep track of all changes to Stories in the Audit table so it wouldn't be too hard to write a query to find the date that a Story's status changed to completed.  At the moment though, this would have to a manual process on your part.  We could certainly help the query if you need.

    Regards,
    Joel
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Thomas
    Thomas avatar
    6 posts
    Member since:
    Aug 2010

    Posted 27 Aug 2010 Link to this post

    Unfortunately I cannot access the database directly from my location, and I'm hesitant to ask to have it opened up so I can access it.  I hear there is a data service for Team Pulse, is it possible to use this service to access this information?  Is there any documentation on the data service?
  4. David Harris
    Admin
    David Harris avatar
    1 posts

    Posted 31 Aug 2010 Link to this post

    Hi Thomas,

    The data service for TeamPulse is a WCF Data Services implementation. We currently do not provide any documentation (we will be releasing an API in the future), but because this is a RESTful service you can inspect it and query it to your leisure.

    To help with your specific request, you could determine the completion time of a story with a query against the Audit table within TeamPulse. This table tracks all changes to all entities within the application on a row-per-property level. So in your case (assuming you are using the default TeamPulse project template where a completed story would be marked as 'Done'), you would be looking for rows where the TableName is equal to 'Story', the FieldName is equal to 'Status', and the NewValue is equal to 'Done'. You'd also likely want to filter by ProjectID, which you can find within your normal TeamPulse URL when accessing the project.

    To make the above call in your browser using a RESTful query, you could use a URL like this (where localhost is the name of the machine TeamPulse is installed to):

    http://localhost:9898/Services/DataService.svc/Audits?$filter=ProjectID%20eq%201%20and%20TableName%20eq%20'Story'%20and%20FieldName%20eq%20'Status'%20and%20NewValue%20eq%20'Done'

    Hopefully this can get you started in extracting the information you require. If you have any further questions please let us know.

    All the best,
    David Harris
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Thomas
    Thomas avatar
    6 posts
    Member since:
    Aug 2010

    Posted 09 Sep 2010 Link to this post

    Thanks David this was very helpful.  I look forward to the documentation of that service!
Back to Top