Test management SQL query to find out the test results associated with a suite

  • Article

One of the customer wanted to know the sql query which he can use to find out the results associated with a suite. Nipun sent the following query: -

 

DECLARE @deletedSuiteId INT

SET @deletedSuiteId = 167 –Replace with appropriate suite Id

SELECT r.*

FROM tbl_testresult r

JOIN tbl_point p

ON r.PartitionId = p.PartitionId

AND r.TestPointId = p.PointId

JOIN tbl_suite s

ON s.PartitionId = p.PartitionId

AND s.SuiteId = p.SuiteId

WHERE s.PartitionId = 1

AND s.suiteId = @deletedSuiteId