HP ALM/QC dashborad

[Anonymous]

Hi All,

Do any body created test management dashboard using HP ALM/QC as source with all tables like , Test, defect, requirement etc.

Could you please share the data model for the same.

what are the relationship between test cases, test ID , defect id and req ID .

Any help will be appreciated.

Thanks in advance

BKC

[Anonymous]

Can anybody plz reply .

[shayraber]

I have one for the HP QC but its confidential and I'm not allowed to take it out of the organization.

What I can give you is website with all tables and the connections between them

check this:

http://systemmanager.ru/322224.en/quality%20center%20database_db.html

the main table that will interest you are:

where:

REL_ID=RCYC_PARENT_ID

RCYC_ID=RQC_CYCLE_ID

RQC_REQ_ID=RQ_REQ_ID=RC_REQ_ID

RC_ENTITY_ID(if RC_ENTITY_TYPE='TEST')=TS_TEST_ID

TS_TEST_ID=RN_TEST_ID

RN_RUN_ID=ST_RUN_ID

ST_TEST_ID=TS_TEST_ID

hope that helps you