Excel Report Query, Linkin requirements to defects
I'm having an issue in getting the right SQL code for getting all defects on all requirements.
I want to show my acceptants which requirements have which defects. You should say it would be easy to generate an excel list using the Excel Report Query designer. After spending 5 hours [img]/images/graemlins/mad.gif[/img] with no result i turned to this site. Hopefully someone here can help me out?
Thanks a lot.
Re: Excel Report Query, Linkin requirements to defects
Use the below query.
Select RQ_REQ_ID,RQ_REQ_NAME, BG_BUG_ID, BG_SUMMARY FROM REQ, LINK, BUG WHERE REQ.RQ_REQ_ID = LINK.LN_ENTITY_ID AND LINK.LN_BUG_ID = BUG.BG_BUG_ID
FYI. If you look in QC help, there's a QC DB Reference file.