Highlighted
BrCo
Visitor.
311 views

Connection between SQL Commands and HP QC

Hello everybody,

I am a beginner in HP QC and I try to export different tests in HP ALM. When you create a new Excel report in Analysis View, then you find the SQL commands in 'Excel Report Query Builder' on the right side. (I use the actual HP QC 12.55)

Is there a document or a list or anything else, where you find the 'applications' of these SQL commends in HP QC?

I mean the following with 'applications': For example TC_TESTCYCL_ID is the command for the field in TestLab -> Execution Grid -> Test Instance ID   or  TC_TEST_CONFIG_ID is the command for the field in TestLab -> Execution Grid -> Configuration: ID  and so on...

Thank you for your help!

Labels (1)
Tags (2)
0 Likes
1 Reply
Knowledge Partner
Knowledge Partner

Re: Connection between SQL Commands and HP QC

Hi Brco,

Please go through below link for HP ALM database object model and for details on tables.

https://admhelp.microfocus.com/alm/en/12.55/api_refs/project_db/webframe.html#topic44.html

Below is the userguide link for Excel Reports:

https://admhelp.microfocus.com/alm/en/12.55/online_help/Content/UG/menu_excel_reports.htm

Regards,Srihari

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.