Excel report generator-SQL Reqs with Defs
Anyone have SQL for the following?
List of requirements with linked defects for a particular app version. My SQL to get the requirements filtered for an app version copied below. But I want to include the defects associated with these requirements. I know there is a way to do this from the Analysis menu in QC, but the format is unacceptable for what I am doing. Getting this using the Excel report generator would be ideal if I could figure out how to write the SQL.
REQ.RQ_USER_06 AS REQID,
REQ.RQ_REQ_NAME AS SUMMARY,
REQ.RQ_REQ_COMMENT AS DESCRIPTION,
REQ.RQ_DEV_COMMENTS AS COMMENTS ,
REQ.RQ_USER_01 AS WFSTATUS,
REQ.RQ_USER_05 AS DEVELOPER
WHERE REQ.RQ_USER_04 = 'CDV1.2'