TestRunQueries

This topic explains how to use test run queries in Agility.

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