It's all about the answers!

Ask a question

Accessing Custom Attributes in BIRT


Bill Taylor (3144) | asked Jan 29 '10, 8:11 a.m.
Custom attributes of type Integer are held in a database table called WORK_ITEM_INT_EXTENSIONS and are accessible in BIRT in table LIVE_WORKITEM_CNT in columns INTEGER_KEY and INTEGER_VALUE.

Custom attributes of type Iteration (internal type name 'interval') are held in a database table called WORK_ITEM_ITEM_EXTENSIONS but I cannot see how they are accessible in BIRT.

Can anybody help? More importantly, where can I find this out for myself?

regards
Bill Taylor

One answer



permanent link
James Moody (3.3k24) | answered Feb 03 '10, 2:23 p.m.
JAZZ DEVELOPER
On 1/29/2010 8:23 AM, bill.taylor wrote:
Custom attributes of type Integer are held in a database table called
WORK_ITEM_INT_EXTENSIONS and are accessible in BIRT in table
LIVE_WORKITEM_CNT in columns INTEGER_KEY and INTEGER_VALUE.

Custom attributes of type Iteration (internal type name 'interval')
are held in a database table called WORK_ITEM_ITEM_EXTENSIONS but I
cannot see how they are accessible in BIRT.

Can anybody help? More importantly, where can I find this out for
myself?

regards
Bill Taylor


(Bill connected with us by email, but thought I'd post a follow-up here
just in case others were interested).

Unfortunately we don't expose this data through the LIVE_WORKITEM_CNT
table at the present. You may be able to use the data exposed by the
LIVE_SNAPSHOT in the com.ibm.team.workitem.WorkItem table to get what
you need.

james
RTC Reports Team Lead

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.