...
Report : Generate a report that displays the count of test cases executed for a sprint i.e cycle grouped by their execution status for a project (Name : Summary of Test Case Execution Status By Sprint).
SQL Query
Summary of Test Case Execution Status By Sprint
Code Block | ||
---|---|---|
| ||
SELECT testexecutions.projectName as "Project Name", testexecutions.releaseName as "Release Name", testexecutions.cycleName as "Sprint", testexecutions.tcExecutionStatusName "TestCase Execution Status", COUNT(1) as "Execution Count" FROM testexecutions WHERE testexecutions.projectID in (`@Filter.project`) GROUP BY testexecutions.releaseName, testexecutions.cycleName, testexecutions.tcExecutionStatusName |
Apply the Filter
...
Query Output
By default, it gives you output in tabular format. You can modify the output format by switching to the available chart types from the table. In our case, we will switch it to the Cross Table report.
...