Release and Cycle ID’s are NULL in Requirments Table

  • Questions
  • Release and Cycle ID's are NULL in Requirments Table
Question ID: 104413
3
0

The Release and Cycle ID’s are NULL in Requirments Table(RQ_TARGET_REL / RQ_TARGET_RCYC).
Does anyone have any idea how to get the Release and Cycle for the Requirement?
Thanks in advance.

Marked as spam
Posted by (Questions: 23, Answers: 1)
Asked on November 23, 2011 4:01 pm
7 views
Answers (1)
3
Private answer

This is confusing to everyone.
Excel Reports does not show the intersection tables.
After looking the Database Reference Guide (HELP / DOCUMENTATION LIBRARY / DATABASE REFERENCE GUIDE)
This query gave me the results I wanted.

SELECT
RQ_REQ_NAME AS ''REQUIREMENT_NAME''
, REL_NAME AS ''RELEASE_NAME''
, RCYC_NAME AS ''CYCLE_NAME''
FROM
REQ
,REQ_RELEASES
,REQ_CYCLES
,RELEASES
,RELEASE_CYCLES
WHERE
RQRL_REQ_ID = RQ_REQ_ID
AND RQC_REQ_ID = RQ_REQ_ID
AND RQRL_RELEASE_ID = REL_ID
AND RQC_CYCLE_ID = RCYC_ID
ORDER BY
RQ_REQ_NAME, REL_NAME, RCYC_NAME

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on November 23, 2011 4:20 pm
Thanks Sammy
( at November 23, 2011 4:22 pm)