Take the 2-minute tour ×
Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. It's 100% free, no registration required.

I am still pretty new here, but couldn't find an answer so far.

I want to know if there are any test cases (if possible of a specific folder in the Test Plan) that have not been linked to a test set, and therefore won't be tested.

We are still at the beginning... and I want to show the testers a list of test cases that they might have forgotten about.

Any help is greatly appreciated.

Thanks and stay safe.

Regina

share|improve this question

2 Answers 2


if you use Quality Center 10, you can use the Excel report in the Dashboard to get your information. The following query will give you the count of test instance in the TestLab. Thus 0 means the test case in TestPlan is not linked to any test instance/TestSet in TestLab.

SELECT 
  tb1.ts_name as "TestCase Name" 
, count(tb3.cy_cycle) as "CountInstance" 
FROM TEST tb1
,TESTCYCL tb2 
,CYCLE tb3
where tb1.ts_test_id = tb2.tc_test_id(+) 
and tb2.tc_cycle_id = tb3.cy_cycle_id(+)
group by ts_name

Basically, you have to link tables Test (TestPlan), TestCycl (TestInstance) and Cycle (TestSet). You cannot link TestPlan directly to TestSet.

Hope this helps.

share|improve this answer

The link below has the ER diagram of TEST, TESTCYCL, and CYCLE tables. Also an example to retrieve the status of the tests. That will give you the results of the test that have not run.

QC Retrieving test status

share|improve this answer
    
What's testcycl? –  dzieciou Dec 4 '12 at 17:26
    
TestCycl is the table in QC database that has records stored for test instanace with in a test set –  Sham Dec 5 '12 at 15:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.