| || |
I'm using Excel reports to get an extract of all defects. However, Detected in Release and Target Release are showing numbers instead of the actual name.
Anyone know how to resolve this? I guess I need to query another table, but a SQL example would help.
Thanks in advance.
Re: Release name
You need to join the BUG and RELEASES tables on BUG.BG_DETECTED_IN_REL = R1.REL_ID and BUG.BG_TARGET_REL = R2.REL_ID.
You need SELECT ... FROM BUG, RELEASES R1, RELEASES R2.
You can download a CHM file that describes the database schema from the Help / Documentation Library... menu in QC client.