Colm_Conlon
Newbie
Reged: 07/19/11
Posts: 12
|
|
Hi, does anyone know the name of the Quality Center database table that holds the Test Set properties description(see attachment)? Regards, Colm
|
Rajkumar_Rajangam
Veteran
Reged: 10/22/10
Posts: 3136
Loc: Norway
|
|
What version of QC is this?
QC 10 -> 'CYCLE ' table -> 'CY_COMMENT' column.
-------------------- Rajkumar
|
Colm_Conlon
Newbie
Reged: 07/19/11
Posts: 12
|
|
Thanks for that Rajkumar. I had actually found it myself just before you responded. Version of QC we are using is 9. It's the same table and column in QC 9('CYCLE ' table -> 'CY_COMMENT' column). Thanks again.
|
Moe10
Member
Reged: 09/22/09
Posts: 253
|
|
I have a problem that when I write a sql query I get confused of which table I have to use. For example, in the Run table, you find RUN_Status and in the TestCycle you find also status there.
Is there any documentation of how each table should be used besides the QC Database schema?
|
ttguy
Member
Reged: 01/28/09
Posts: 267
Loc: Canberra
|
|
In QC 9.2 there is a HP Quality Center Database Reference.chm compiled help file that describes the database schemas and is quite useful
|
Moe10
Member
Reged: 09/22/09
Posts: 253
|
|
Thank you, TT
|
vasanths_81
Newbie
Reged: 09/28/11
Posts: 2
|
|
need the query and connectivity details to connect QC database, thanks and regards, vasanth
|
kaktusgruen
Member
Reged: 09/07/11
Posts: 29
|
|
Is there any Database Table for QC11?
I cant find one.
regards, kaktus
Edited by kaktusgruen (09/29/11 05:58 AM)
|
Rajkumar_Rajangam
Veteran
Reged: 10/22/10
Posts: 3136
Loc: Norway
|
|
Where are you looking?
-------------------- Rajkumar
|
kaktusgruen
Member
Reged: 09/07/11
Posts: 29
|
|
I was looking in the install folder and in the Documentation Library.
There is a Link in the Documentation Library to HP ALM Project Database Reference, but the document isnt actually there. It will come with the next patch.
regards
|
Trudy
Advanced Member
Reged: 11/21/06
Posts: 524
|
|
The document (chm file) is there in the Documentation Library as of Patch 2, however you might not be able to open it directly from that link due to a Microsoft security hotfix. Download the file to your workstation and then open it locally.
-------------------- Trudy C
(Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)
|