Folders and child nodes are not considered. You can use this view to create a report that shows the status of your test runs for each execution plan in a folder. In contrast to RV_ExecutionPlanStatusRollup, this view has a slight performance advantage as no hierarchy is considered for retrieving the data. The key of this table is the combination of the columns ExecutionPlanID and BuildID.
| Row | Description |
|---|---|
| ExecutionPlanID | Identifier of the execution plan. |
| BuildID | Identifier of the build. |
| ExecutionPlanName | Name of the execution plan. |
| ExecutionParentFolderID | ID of the execution plan's parent. |
| PassedCount | Sum of all passed tests. |
| FailedCount | Sum of all failed tests. |
| NotExecutedCount | Sum of all not-executed tests. |
| ProjectID | ID of the project that the execution plan belongs to. |
| 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. |