How do I query the "Related Artifact" link type in Report Builder?
I have CCM work items that contain the link type "Related Artifact", which contains the URL (permalink) to an RM artifact. In Report Builder, I need to grab the work item (I can do that) and its associated RM artifact via that link. That is, I can't use the "Implements/Implemented By" pair, or things like that.
Problem is, I cannot figure out which tables (views), columns, and values to use. I figure I have to modify the auto-generated SQL, but have had no luck in guessing the names.
I did try using a join to the RIDW.VW_REQUIREMENT_REQUEST_LOOKUP table with LINK_TYPE = 'com.ibm.team.workitem.linktype.relatedartifact', but that did not work. I suspect because this link type is not available on the RM side, only the CCM side (in our installation, I guess) - and so suspect there is some special mechanism for it?
Anyone have any ideas?
Both RM and CCM versions are 6.0.1.