It's all about the answers!

Ask a question

Reporting on join between two different work item types


Greg Hodgkinson (2092120) | asked Mar 26 '10, 7:52 a.m.
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



permanent link
Rafik Jaouani (5.0k16) | answered Mar 26 '10, 12:01 p.m.
JAZZ DEVELOPER
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.

permanent link
Greg Hodgkinson (2092120) | answered Mar 26 '10, 1:56 p.m.
Thanks very much Rafik. I will try as you suggest.

Your answer


Register or 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.