Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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