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