This is a migrated thread and some comments may be shown as answers.

Date Completed Column for exporting to CSV/Excel?

4 Answers 65 Views
Reports and Analytics
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Thomas
Top achievements
Rank 1
Thomas asked on 26 Aug 2010, 04:34 PM
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?

4 Answers, 1 is accepted

Sort by
0
Joel
Telerik team
answered on 27 Aug 2010, 10:32 PM
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
0
Thomas
Top achievements
Rank 1
answered on 27 Aug 2010, 11:13 PM
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?
0
David Harris
Telerik team
answered on 31 Aug 2010, 08:22 PM
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
0
Thomas
Top achievements
Rank 1
answered on 09 Sep 2010, 05:18 PM
Thanks David this was very helpful.  I look forward to the documentation of that service!
Tags
Reports and Analytics
Asked by
Thomas
Top achievements
Rank 1
Answers by
Joel
Telerik team
Thomas
Top achievements
Rank 1
David Harris
Telerik team
Share this question
or