Test Lab Question
In my project we have 350 test cases,there is no requirements mapped to these test cases.
And these test cases are scheduled in 7 cycles,may be same test case might failed in one cycle and passed in another cycle.
How can i get the following details:
1. whether all test cases are pulled to test set or not?
2. How can i get a report with how many total passed, failed, no run...or other statuses.
I have to pull daily reports for different projects.
As there are so many cycles, i was not able to get the details correctly.
I am using QC 10.0
Re: Test Lab Question
There are a few ways of retrieving the data. Using OTA API, raw SQL queries, custom or 3d party reporting solutions are the options.
I can help with SQL queries (I test databases often). Here is the SQL to review tests which are not assigned to any test set:
select ts_test_id, ts_name, ts_status, ts_responsible, ts_type
from test where ts_test_id not in (select tc_test_id from testcycl)