UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21. Read more.
UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21.Read more.
Absent Member.
Absent Member.
194 views

how to query in sql to find the planned no of test cases vs executed?

 
0 Likes
1 Reply
Absent Member.
Absent Member.

It depends on what is meant by 'planned' and executed.

 

I assume that 'planned' are those tests that are included in test set, but have status 'NO RUN', and the rest of the tests are those that were executed and therefore have certain status.

 

So sql query should be something like:

SELECT
"test_set"."CY_CYCLE" AS "name",
"test_instance"."TC_STATUS" AS "status",
count("test_instance"."TC_STATUS") AS "Count"
FROM
CYCLE "test_set"
INNER JOIN TESTCYCL "test_instance" ON "test_set"."CY_CYCLE_ID" = "test_instance"."TC_CYCLE_ID"
GROUP BY
"test_set"."CY_CYCLE",
"test_instance"."TC_STATUS"

 

This will show you how many test instatces in what test set with wgat status.

 

Hope that will help you

 

 

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.