Use the RV_TestStatusExtended view to retrieve information about all test runs. You can use this view to create a report that lists all failed tests in an execution folder. The key of this table is the combination of the columns TestID, ExecutionPlanID, BuildID, and TestRunID.
| Row | Description |
|---|---|
| TestID | Identifier of the test. |
| ExecutionPlanID | Identifier of the execution plan. |
| BuildID | Identifier of the build. |
| TestRunID | Identifier of the test run. |
| ExecutionRunID | Identifies in which execution run this result was generated. |
| StatusID | Status of this test run (see TM_TestDefStatusNames). |
| ReasonID | Reason for the status of this test run (see TM_ResultStatusReasons). Can be null. |
| PassedCount | Sum of all passed tests, which is 0 or 1 for common tests and can be more for package test roots. |
| FailedCount | Sum of all failed tests, which is 0 or 1 for common tests and can be more for package test roots. |
| NotExecutedCount | Sum of all not-executed tests, which is 0 or 1 for common tests and can be more for package test roots. |
| ProjectID | ID of the project that this row belongs to. |
| TestStartTime | Time when the test run started (UTC). |
| ExecutionStartTime | Time when the execution run started (UTC). |
| TestDurationInMilliseconds | Duration of the test run in milliseconds. |
| IsBlocked | Flags the test run as blocked/unblocked |
| DbChangedAt | Time when this row was last updated by the reporting data mart. |
| TestName | Name of the test. |
| TestDescription | Description of the test. |
| TestParentID | ID of the test's parent. |
| PlannedTimeInMinutes | Time planned for this test in minutes. |
| Reason | Name of the reason. Can contain reasons that have been deleted in the meantime. |
| ExecutionPlanName | Name of the execution plan. |
| ExecutionPlanDescription | Description of the execution plan. |
| ExecutionParentFolderID | ID of the execution plan's parent. |
| Priority | Priority of the execution plan: 0 = Low, 1 = Medium, 2 = High. |
| BuildName | Name of the build used for this test run. |
| BuildDescription | Description of the build. |
| BuildOrderNumber | Order number of the build. |
| BuildIsTagged | 1 if the build is tagged, 0 otherwise. |
| VersionID | ID of the version that the build belongs to. |
| VersionName | Name of the version. |
| VersionDescription | Description of the version. |
| VersionOrderNumber | Order number of the version. |
| ProductID | ID of the product that the build belongs to. |
| ProductCode | Name of the product. |
| ProductDescription | Description of the product. |
| ProductOrderNumber | Order number of the product. |