Hi,
I am trying to get the execution results by test container (or containers) and the execution results are not the same as the sql report(reporting across all test containers) I am using. Looking for some help as to what I am missing or what is used wrong in the sql.
sql I am using:
SELECT a.TestContainerName AS "Test Container", Sum(a.Passed) AS Passed,
Sum(a.Failed) AS Failed, Sum(a.NotExecuted) AS "Not Executed",
Sum(a.NotAvailable) AS "N/A"
FROM
(
SELECT td.TestContainerName, th.TreeOrder,
CASE when td.TestCovStatusID=1 then 1 else 0 end AS Passed,
CASE when td.TestCovStatusID=2 then 1 else 0 end AS Failed,
CASE when td.TestCovStatusID=3 then 1 else 0 end AS NotExecuted,
CASE when td.TestCovStatusID=4 then 1 else 0 end AS NotAvailable
FROM
(
SELECT DISTINCT tds.TestContainerID, tds.TestContainerName, tds.TestID,
CASE when tds.CurrentExecStatus=8 then 1
else CASE when tds.CurrentExecStatus=9 then 2
else tds.CurrentExecStatus end
end AS TestCovStatusID
FROM RTM_V_Tests_NoTreeOrder tds
WHERE ProjectID = ${$PROJECTID}
) td INNER JOIN RTM_V_TestHierarchie th ON (th.NodeID_pk = td.TestContainerID)
) a
GROUP BY a.TestContainerName, a.TreeOrder
ORDER BY a.TreeOrder
the results from the sql:
this is the execution results overview report is displaying:
thanks!
