The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:
Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Testing Tools >> HP ALM / Mercury Quality Center

Pages: 1
Colm_Conlon
Newbie


Reged: 07/19/11
Posts: 12
Quality Center Database Table
      #680249 - 07/27/11 03:06 AM Attachment (177 downloads)

Hi, does anyone know the name of the Quality Center database table that holds the Test Set properties description(see attachment)?
Regards,
Colm


Post Extras: Print Post   Remind Me!   Notify Moderator  
Rajkumar_Rajangam
Veteran


Reged: 10/22/10
Posts: 3136
Loc: Norway
Re: Quality Center Database Table [Re: Colm_Conlon]
      #680253 - 07/27/11 03:35 AM

What version of QC is this?

QC 10 -> 'CYCLE ' table -> 'CY_COMMENT' column.

--------------------
Rajkumar


Post Extras: Print Post   Remind Me!   Notify Moderator  
Colm_Conlon
Newbie


Reged: 07/19/11
Posts: 12
Re: Quality Center Database Table [Re: Rajkumar_Rajangam]
      #680265 - 07/27/11 04:34 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Moe10
Member


Reged: 09/22/09
Posts: 253
Re: Quality Center Database Table [Re: Rajkumar_Rajangam]
      #685361 - 09/14/11 06:56 PM

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?


Post Extras: Print Post   Remind Me!   Notify Moderator  
ttguy
Member


Reged: 01/28/09
Posts: 267
Loc: Canberra
Re: Quality Center Database Table [Re: Moe10]
      #685372 - 09/14/11 09:40 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
Moe10
Member


Reged: 09/22/09
Posts: 253
Re: Quality Center Database Table [Re: ttguy]
      #685476 - 09/15/11 07:27 AM

Thank you, TT

Post Extras: Print Post   Remind Me!   Notify Moderator  
vasanths_81
Newbie


Reged: 09/28/11
Posts: 2
Re: Quality Center Database Table [Re: Moe10]
      #686993 - 09/29/11 01:40 AM

need the query and connectivity details to connect QC database, thanks and regards, vasanth

Post Extras: Print Post   Remind Me!   Notify Moderator  
kaktusgruen
Member


Reged: 09/07/11
Posts: 29
Re: Quality Center Database Table [Re: vasanths_81]
      #687028 - 09/29/11 05:58 AM

Is there any Database Table for QC11?

I cant find one.

regards,
kaktus

Edited by kaktusgruen (09/29/11 05:58 AM)


Post Extras: Print Post   Remind Me!   Notify Moderator  
Rajkumar_Rajangam
Veteran


Reged: 10/22/10
Posts: 3136
Loc: Norway
Re: Quality Center Database Table [Re: kaktusgruen]
      #687037 - 09/29/11 06:28 AM

Where are you looking?

--------------------
Rajkumar


Post Extras: Print Post   Remind Me!   Notify Moderator  
kaktusgruen
Member


Reged: 09/07/11
Posts: 29
Re: Quality Center Database Table [Re: Rajkumar_Rajangam]
      #687040 - 09/29/11 06:54 AM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
Trudy
Advanced Member


Reged: 11/21/06
Posts: 524
Re: Quality Center Database Table [Re: kaktusgruen]
      #687066 - 09/29/11 09:33 AM

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.)


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1



Extra information
0 registered and 35 anonymous users are browsing this forum.

Moderator:  Rich W., AJ, jgottlieb 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 5975

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5