Absent Member.
Absent Member.
379 views

trying to create a sql report for execution results by test container (similar to the project overview report)...

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!

0 Likes
1 Reply
Absent Member.
Absent Member.

I found what I was looking for, no need to reinvent the wheel 🙂

test status overview and test status (per test container) are the reports I need.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.