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.