vw_TestResult and other Testing Views

Question

We have some custom reports written for capturing test results. I am just picking them up and am not the original author. I have some concerns about the data being returned by the reports and need to verify what I am seeing is correct.

The reports make use of the views in the operational Database of our team project collection and include vw_TestResult, vw_Plan, vw_Suite and vw_TestRun. (not sure this is how they should have been written)

I have been working through the views to understand them as I can't seem to find any good references on them.

Can someone point me to documentation on these views. I am specifically looking for information describing what I would assume to be foreign keys. For instance in vw_TestResult There is an outcome column. This contains numerical values and is pulled from the Outcome column of tbl_TestResult. When looking at this table there is no foreign key to lead me to the list of available options and their human readable text elements.

I'm not sure these tests are authored in accordance with best practices, but like I said I am just picking them up now and am trying to move forward.

Answer 1

Querying these views is not supported, hence the lack of documentation. Querying is supported on the TFS_Warehouse database. You can also retrieve the data from the operational database through the .NET API or through the new ODATA services.

See also: 

- http://msdn.microsoft.com/en-us/library/bb649552 (Warehouse)
- http://msdn.microsoft.com/en-us/library/dd470570 (TFS API)

---

My blog: blog.jessehouwing.nl

Answer 2

Thanks Jesse,

I was suspecting this to be the answer, but it doesn't hurt to ask.  I'll read through the links and go from there.

I appreciate the reply.

Regards,

Bill