Count for all test steps per test case

[JamesA99]

Hi All, looking at options for a sql report that counts test steps per test case...

I have this SQL but wondering if it can be modified to add a count of steps for easier readability:

SELECT td.TestContainerName, td.ProjectID, td.TestID, td.TestName, ms.Name [TestStep Name],
ms.Description [TestStep Description],
ms.Result [TestStep Result]
FROM TM_V_TestDefinitions td left outer join TM_V_ManualSteps ms
on td.TestID = ms.TestAssetNodeID_fk
WHERE td.TestContainerID = ${TestContainerID |0|TestContainerID}

[Hubert Inreiter]

Hi James,

This query counts the steps per test within a test container:

SELECT td.TestContainerName, td.ProjectID, td.TestID, td.TestName, COUNT(ms.TestAssetNodeID_fk) StepsCount

FROM TM_V_TestDefinitions td

left outer join TM_V_ManualSteps ms on td.TestID = ms.TestAssetNodeID_fk

WHERE td.TestContainerID = ${TestContainerID |0|TestContainerID}

GROUP BY td.TestContainerName, td.ProjectID, td.TestID, td.TestName

Regards,

Hubert

[JamesA99]

Thanks Hubert...this works great, your help is much appreciated!