Getting the attributes of a custom work item type (reports)
Hi folks,
I have a custom work item type in RTC 2.0, and I'm having trouble pulling live information about it into a BIRT report. How can I retrieve the list of custom attributes on a custom work item type?
I can find the custom work item type in the TYPE table:
Given a work item number, I can retrieve the custom attributes that are attached to that work item from the LIVE_WORKITEM_CNT table:
However, I can't find a table that lists the custom attributes that are on my custom work item type. Is there a table that links the custom type to the attributes that are on that type?
I have a custom work item type in RTC 2.0, and I'm having trouble pulling live information about it into a BIRT report. How can I retrieve the list of custom attributes on a custom work item type?
I can find the custom work item type in the TYPE table:
TYPE_ID WI_TYPE
_Efk74JKzEdyxEJbWRNPMrQtMyWIType MyWIType
Given a work item number, I can retrieve the custom attributes that are attached to that work item from the LIVE_WORKITEM_CNT table:
WI_ID WI_TYPE STRING_KEY STRING_VAL
1234 MyWIType MyAttribute1 myenumeration.literal.l2
1234 MyWIType MyAttribute2 myenumeration.literal.l1
1234 MyWIType MyAttribute3 myenumeration.literal.l2
1234 MyWIType MyAttribute4 myenumeration.literal.l1
etc...
However, I can't find a table that lists the custom attributes that are on my custom work item type. Is there a table that links the custom type to the attributes that are on that type?
Accepted answer
On 10/16/2009 2:08 PM, tmcmack wrote:
I don't think there's any way to get this information, other than from a
single work item like you mention above. This information is (obviously)
stored in the project specification in the repository, but the work
items data set doesn't give you a way to access that information.
james
RTC Reports Team Lead
Hi folks,
I have a custom work item type in RTC 2.0, and I'm having trouble
pulling live information about it into a BIRT report. How can I
retrieve the list of custom attributes on a custom work item type?
I can find the custom work item type in the TYPE table:
TYPE_ID WI_TYPE
_Efk74JKzEdyxEJbWRNPMrQtMyWIType MyWIType
Given a work item number, I can retrieve the custom attributes that
are attached to that work item from the LIVE_WORKITEM_CNT table:WI_ID WI_TYPE STRING_KEY STRING_VAL
1234 MyWIType MyAttribute1 myenumeration.literal.l2
1234 MyWIType MyAttribute2 myenumeration.literal.l1
1234 MyWIType MyAttribute3 myenumeration.literal.l2
1234 MyWIType MyAttribute4 myenumeration.literal.l1
etc...
However, I can't find a table that lists the custom attributes that
are on my custom work item type. Is there a table that links the
custom type to the attributes that are on that type?
I don't think there's any way to get this information, other than from a
single work item like you mention above. This information is (obviously)
stored in the project specification in the repository, but the work
items data set doesn't give you a way to access that information.
james
RTC Reports Team Lead