SQL query to retrieve TEST Set names and their Info
Am new to this and I need to create a many reports, one of them is listing out all the test set names in given cycle and their Information( Number of test cases, percentage complete, planned start date, planned end date, actual start date, actual end date using SQL query. Am using Microsft SQL server. Your guidnace much appreciated.
We can extract multiple information from table: TESTCYCL
There loads and saves all the information related to test sets.
I will recommend to involve your DB team, so you can get the info needed for test sets.
Find more details in next link: https://admhelp.microfocus.com/alm/en/12.55/api_refs/project_db/webframe.html#topic595.html
I found this query some years ago and with a little tweaking it may give you what you need.
(Statements expressed here are mine alone, and do not reflect the opinions of my employer.)