The RV_TestStatusExtended view provides detailed information for a certain test execution.

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.

Note: Tests and depending test runs are removed from the data mart if a test is deleted. This also applies to deleted tests due to cleaning up test packages.
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.