RV_LatestTestStatus

The RV_LatestTestStatus view provides status and extended information on the latest test run of a test within the context of a specific execution plan and build.

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.