TFS API: How to get latest test result for a test case

-
We can retrieve test results for particular test case using TFS API. That's straight forward and there are in build methods. I find people asking for how they can retrieve latest test result for particular test case and I got it solved so thought of sharing here. below code snippet will illustrate how to -

1. Connect to TFS Server/Collection/team project
Uri tfsUri = new Uri("http://servername:8080/tfs/collectionname");
teamProjectCollection = new TfsTeamProjectCollection(tfsUri);
 
iTestManagementService = teamProjectCollection.GetService<ITestManagementService>();
tfsConnectedTeamProject = iTestManagementService.GetTeamProject("Team Project Name");
 
2. Once connected to TFS server, call APIs to get test results for any particular test case. Below line of code will get all results associated with passed test case Id and this returned list is not sorted

var testResults = tfsConnectedTeamProject.TestResults.ByTestId(52737);

3. We can sort this using below code using LastUpdated property of ITestCaseResult and it will return you sorted list of test result.

var resSort = from res in testResults
orderby res.LastUpdated descending
select res;
 
4. Now if you need only latest test result from result collection then below is code. Use above sorted list and retrieve top most record.

var latestTestResult = resSort.First<ITestCaseResult>();

Hope this help you all.

Thanks,
Vivek

Comments

Post a Comment

Popular posts from this blog

How To: Bulk upload Test Case results to Microsoft Test Manager

-
Problem Definition: Most TFS or Microsoft Test Manager users find it difficult to update test execution result to MTM. Assume that you are done with 100+ test case execution manually and now you want to upload results (Pass/Fail/Block) for all those test cases and also link bugs, test cases to result as needed. Doing this manually is very time consuming. At this time there is no way to support this ask in MTM versions but yes, we can achieve this by writing our own code using TFS SDK APIs. Resolution: I came along with this issue some time back and created a tool using TFS APIs which upload results to MTM very smoothly. Here is how my tool works:   1. Run tool exe  2. Connect to team foundation server you want to  3.  Select test plan -> Test Suite  4. Click Get Test Case button  5. This will create excel with test cases from selected test suite.  6. There is filter if you want to upload results specifically for manual or automated or all test cases  7.  Open created excel and
Read more

TFS API: Get Work Item History Revisions for parituclar Field

-
Image
Hello, I observed many of us struggling to view history for any work item. History is visible but it is hard to visualize changes made like who made changes, to which field and when etc. For this matter, one has to scroll through entire history tab and find it tedious job. I was thinking what if we could view work item history for selected field with other details like who changed it and when. Here is solution - I have created a tool which show work item history for selected field. Also shows how may times selected field changed. You can view history by selecting single work item and also export entire work item query history to excel. I find this tool useful so thought of sharing with others. How it works - 1. Run EXE 2. Prompt you select/add team project server details 3. Populates your My Queries to Treeview 4. Double Click query from tree and it will show work items in right grid 5. Select Work item field from top drop down for which you want to see history 6. Doubl
Read more

Add attachment to Test Case Result using TFS API

-
We can add attachment to test case result using TFS APIs. Here is small code snippet I have created. ITestRun testRun = _plan . CreateTestRun ( false ); ITestCaseResultCollection results = testRun . QueryResults (); ITestIterationResult iterationResult ;   foreach ( ITestCaseResult result in results ) {      result . Attachments . Add ( new Attachment ( "FileName" , "Comments if any" )); }   results . Save ( true ); testRun . Save (); testRun . Refresh ();
Read more