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. |