The RV_ExecutionPlanStatusPerBuild view retrieves the latest test status sums for every execution plan in context of builds.

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.