LINK_TYPE in LINKS table of COMMON snapshot
Hi all
I am currently working on developing custom BIRT reports and found this article by Tim as a big boon to report developers.
http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part1/index.html
I learnt that its possible to fetch child records in BIRT reports by using LINK_TYPE column in LINKS table of COMMON snapshot. From the article I know we can use the 'com.ibm.team.workitem.linktype.parentworkitem' for fetching childred WI. What are the other relationships that can be pulled out using the LINK_TYPE column?
Regards
Vinay Kv Anmaruthai
I am currently working on developing custom BIRT reports and found this article by Tim as a big boon to report developers.
http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part1/index.html
I learnt that its possible to fetch child records in BIRT reports by using LINK_TYPE column in LINKS table of COMMON snapshot. From the article I know we can use the 'com.ibm.team.workitem.linktype.parentworkitem' for fetching childred WI. What are the other relationships that can be pulled out using the LINK_TYPE column?
Regards
Vinay Kv Anmaruthai
One answer
What are the other relationships that can be pulled out using the LINK_TYPE column?i
Glad that you found the articles helpful. I had a look in the plugin com.ibm.team.workitem.common in the file plugin.xml. This file lists the extensions to com.ibm.team.repository.common.linkTypes, which define the types of links. Here is what I see in RTC 2.0.0.2:
com.ibm.team.workitem.linktype.relatedChangeManagement: Related Change Request
com.ibm.team.workitem.linktype.blocksTestExecutionRecord: Blocks Test Execution
com.ibm.team.workitem.linktype.affectsExecutionResult: Affects Test Execution
com.ibm.team.workitem.linktype.testedByTestCase: Tested By Test Case
com.ibm.team.workitem.linktype.implementsRequirement: Implements Requirement
com.ibm.team.workitem.linktype.relatedworkitem: Related
com.ibm.team.workitem.linktype.duplicateworkitem: Duplicated By
com.ibm.team.workitem.linktype.copiedworkitem: Copied From
com.ibm.team.workitem.linktype.relatedartifact: Related Artifacts
com.ibm.team.workitem.linktype.attachment: Attachments
com.ibm.team.workitem.linktype.blocksworkitem: Blocks
com.ibm.team.workitem.linktype.parentworkitem: Parent
com.ibm.team.workitem.linktype.textualReference: Mentions
Edit: There are more link types in RTC 3.0; you can look them up in the same place: in the plugin.xml file of the plugin com.ibm.team.workitem.common.