Skip to main content
System StatusContact Support
VersionOne Community

TestRunQueries

  1. Last updated
  2. Save as PDF

This feature is available in Enterprise and Ultimate editions.

Test Runs

select DateKey, TestSuiteName, count(TestRunKey) as TestRunCount, sum(Passed) as Passed, sum(Failed) as Failed, sum(NotRun) as NotRun
from Fact.TestRun TR
    join Dim.TestSuite TS on TR.TestSuiteKey = TS.TestSuiteKey
    join Dim.Project P on P.ProjectTestSuiteKey = TS.TestSuiteKey
    join Dim.AssetState S on TS.TestSuiteAssetState = S.AssetStateName
where ProjectName='Release 1.0' and AssetStateName = 'Active'
group by DateKey, TestSuiteName
order by DateKey