创建测试结果的查询 [英] Creating a query for test outcome

问题描述

我想创建一个包含测试结果（通过，失败，阻止等）的查询。我能够创建一个包含此级别信息（测试用例和结果）的图表，但需要原始数据进行报告。有哪些选择？
测试运行视图不是很有用，因为它不包含结果列。

I would like to create a query that includes the test outcome (Passed, Failed, Blocked, etc.). I was able to create a chart that contains this level of information (test cases and outcome), but need the raw data for reporting. What options are available? The test runs view is not very helpful since it doesn't include the outcome column.

谢谢，

Sol

推荐答案

Hi Sol，

Hi Sol,

您可以使用Excel中的数据透视表和数据透视图报表，通过使用SQL Server Analysis Services多维数据集中的"测试"透视图来创建测试结果报告。

You could use PivotTable and PivotChart reports in Excel to create test results reports by using the Test perspective in the SQL Server Analysis Services cube.

有一个Analyze链接，并使用测试视角报告测试结果：

There is a link for Analyze and report on test results using the test perspective:

https://www.visualstudio.com/en-us/docs/report/sql-reports/perspective-test-analyze-报告测试结果

有关使用Excel创建TFS报告的更多信息，请参阅以下链接：
http://tech.lds.org/wiki/TFS_Reports_using_Excel

For more information of create TFS Reports using Excel, refer to this link: http://tech.lds.org/wiki/TFS_Reports_using_Excel

最好的问候

这篇关于创建测试结果的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！