In which latest build is a defect included in?

Hi all,

to find out in which builds a defect is included in you can open a defect record, switch to the Links tab and check in the Links section the entries Included in Builds.

How can I show the latest build a defect is included in with a pretty list?

I tried constructing a query, but the Links attribute cannot be shown. :(

Then I tried to create a BIRT report. I found promising information in the LINKS table of the COMMON_SNAPSHOTS. :)
The LINK_TYPE com.ibm.team.build.linktype.includedWorkItems shows me through the SOURCE_ITEMID and the TARGET_ITEMID which builds and workitems are connected. :)
So far - so good. Now I had to translate the cryptic TARGET_ITEMID into the workitem id and its summary. I did it with a join of the LIVE_WORKITEM_CNT and the LINKS table. It worked, now I can see the work items belonging to the TARGET_ITEMID. :)
Next I had to translate the SOURCE_ITEMID to the readable build name. Now I am stuck :(
Where can I find a table that supplies me with the build name and its cryptic build_itemid ? The BUILD_SNAPSHOT does not record this information. I am clueless. :?:

Thanks for any information regarding this topic!

Cheers, Harold.

btw. We are using RTC v2.0.0.2 with iFix 4