Jazz Register Log in
Jazz Forum Welcome to the Jazz Community Forum

Welcome to the Jazz Community Forum

Connect and collaborate with IBM Engineering experts and users

BIRT - Work Item List Custom Field - Where's the data

I have a custom field of the "Work Item List" type and want to report on this field in a BIRT report. I have successfully worked with other custom fields using the fields such as STRING_KEY/STRING_VAL pairs, but I don't see the data for my Work Item List field in any of these xxxKEY/xxxVAL fields.

Anyone know where I can find this data?

Thanks

RTC 2.0.0.2

0 votes



2 answers

Permanent link
Item references (such as your work item list field) are not exposed through LIVE_WORKITEM_CNT. However, they are exposed through the LIVE_SNAPSHOT/com.ibm.team.workitem.WorkItem table, which is otherwise very similar to LIVE_WORKITEM_CNT. So I suggest that you use that table if you need access to item references.

james
RTC Reports Team Lead


I have a custom field of the "Work Item List" type and want to report on this field in a BIRT report. I have successfully worked with other custom fields using the fields such as STRING_KEY/STRING_VAL pairs, but I don't see the data for my Work Item List field in any of these xxxKEY/xxxVAL fields.

Anyone know where I can find this data?

Thanks

RTC 2.0.0.2

0 votes


Permanent link
James - Thanks very much. Not quite sure why I coudn't figure that one out myself. :oops:
Ethan

0 votes

Your answer

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

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,989

Question asked: Oct 05 '11, 5:22 p.m.

Question was seen: 6,288 times

Last updated: Oct 05 '11, 5:22 p.m.

Confirmation Cancel Confirm