This view contains all test runs, in contrast to the view RV_LatestTestStatus which contains only the latest test run of a test within the context of an execution plan and a certain build. You can use this view for example to create a report that lists all test runs of your tagged builds. 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. |