Reporting on join between two different work item types
Hi
I have a custom attribute of type Work Item on a specific work item type which is used to relate to another work item. i.e. WorkItemA.related -> WorkItemB. I'd like to create a report template that lists all of these work items (WorkItemA), grouped by the related work items (WorkItemB). I'm new to BIRT but have successfully created a report which just lists my work items using the LIVE_WORKITEM_CNT table. Also from the notes here (https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20) I've seen there is the ability to list custom attributes of various types ... but don't see any mechanism for listing custom attributes of type Work Item. Does anyone know of a way to do this? Would be very much appreciated! |
2 answers
LIVE_WORKITEM_CNT does not expose Item extensions. It only exposes the simple type extensions. For the simple type extensions check the columns named: XXX_KEY and XXX_VAL.
If you are using 2.0.0.2 or better, you can look in the LIVE_SNAPSHOT/com.ibm.team.workitem.WorkItem table. This table has two columns named: itemExtensions.key and itemExtensions.value.itemId. The above table exposes internal implementation details of work item objects. So use it only if necessary as the structure it exposes could change in the future. |
|
Thanks very much Rafik. I will try as you suggest.
|