QC 10 Risk Analysis Report by Release

  • Questions
  • QC 10 Risk Analysis Report by Release
Question ID: 104538
1
0

I am trying to get a comprehensive report out of QC 10 that goes from Requirements to Releases to Coverage to Defects and includes the Risk information. I cannot seem to get the Target Release based on the Requirement ID and I have tried several of the methods I found on HP’s site. Too bad they don’t still use the RQ_TARGET_REL field, *sigh*. The report includes Target Release, Requirement, Test Case, Test Plan Status, Test Plan Priority, Risk Testing Level, Overall Risk, Last Risk Assessment, Last Exec Status, Last Exec Date, Test Type, Linked Defects. Do I really need this much code to find a value for Target Release? Can I just use the API and ReqFactory? I’ve been unsuccessful there as well but…


SELECT
 REQ.RQ_REQ_ID as "REQ ID",
 REQ.RQ_REQ_NAME as "Req Name",
 REQ.RQ_REQ_STATUS AS "Req Status",
 REL_NAME AS "Target Release",
 RCYC_NAME AS "Target Cycle",
 TEST.TS_NAME as "Test Name",
 TEST.TS_EXEC_STATUS as "Test Status"
FROM REQ
 JOIN REQ_CYCLES ON REQ.RQ_REQ_ID = REQ_CYCLES.RQC_REQ_ID
 JOIN RELEASE_CYCLES ON RCYC_ID = RQC_CYCLE_ID
 JOIN RELEASES ON REL_ID = RELEASE_CYCLES.RCYC_PARENT_ID
 JOIN REQ_COVER on REQ.RQ_REQ_ID = REQ_COVER.RC_REQ_ID
 JOIN TEST on TEST.TS_TEST_ID = REQ_COVER.RC_ENTITY_ID
Order by RQ_REQ_ID
Marked as spam
Posted by (Questions: 2, Answers: 0)
Asked on July 5, 2012 3:15 pm
13 views
Answers (1)
1
Private answer

Good Afternoon Cathy,

It looks like you are missing the reference to the REQ_RELEASES table. This table is an associative table linking requirements to releases. Where RQRL_REQ_ID = REQ.RQ_REQ_ID, and RQRL_RELEASE_ID = RELEASES.REL_ID

Hope this Helps.

Marked as spam
Posted by (Questions: 1, Answers: 69)
Answered on February 15, 2013 5:24 pm