RV_LatestFinishedTestStatus

The RV_LatestFinishedTestStatus view provides status and extended information on the latest test run of a test within the context of a specific execution plan and build. This view provides similar information as the RV_LatestTestStatus view, but only for test runs within finished execution plan runs.

Use this view to create reports that ignore currently running execution plans.

Use the RV_TestStatusExtended view to retrieve information about all test runs. 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. For additional information, see the TM_TestDefStatusNames table in the database schema of Silk Central.
EDRStatusID Status of this execution run. For example, status 7 = pending manual run, status 10 = pending automated run. For additional information, see the TM_TestDefStatusNames table in the database schema of Silk Central.
ReasonID Reason for the status of this test run. Can be null. For additional information, see the TM_ResultStatusReasons table in the database schema of Silk Central.
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.