Highlighted
Cadet 3rd Class
Cadet 3rd Class
345 views

SQL query to retrieve TEST Set names and their Info

Hi,

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.

Thanks.

0 Likes
2 Replies
Highlighted
Commander
Commander

Hello, 

 

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 

 

Thank you

Best Regards

 

 

0 Likes
Vice Admiral Vice Admiral
Vice Admiral

Hi there,

I found this query some years ago and with a little tweaking it may give you what you need.

https://community.softwaregrp.com/t5/Quality-Center-ALM-User/how-to-generate-testcases-into-excel-from-test-lab/m-p/1062729#M65269

Regards,

(Statements expressed here are mine alone, and do not reflect the opinions of my employer.)

 

 

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.