Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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.

0 votes


Be the first one to answer this question!

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,023

Question asked: Sep 18 '18, 5:05 p.m.

Question was seen: 688 times

Last updated: Sep 18 '18, 5:05 p.m.

Confirmation Cancel Confirm