Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RTC data warehouse with custom attributes

Questions
Tags
Users
Badges
Harald Lahner
(28●8●10) Dec 01 '11, 8:41 a.m.
Hi all,

we have defined a custom attribute in one of our project areas named "Phase found" of the type Iteration.
When I look into the data warehouse into the WORKITEMS_SNAPHSOT I cannot find the data field in any of the WC_*_EXT or WS_*_EXT tables.
I found it in the LIVE_SNAPSHOT in the table com.ibm.team.workitem.WorkItem under the data field itemExtensions.

Are the custom fields not recorded in the data warehouse? Or am I searching in the wrong table?

We are running RTC v2.0.0.2 with iFix 6.

Thanks for any help.
Harold.

0 votes

2 answers
5,825 views
0 votes

2 answers

Permanent link
Rafik Jaouani
JAZZ DEVELOPER (5.0k●1●6) Dec 11 '11, 10:10 a.m.
RTC only collects custom attributes of the primitive types.

1 vote

Permanent link
Milan Krivic
(980●13●176●143) Dec 11 '11, 3:02 p.m.
Hi all,

we have defined a custom attribute in one of our project areas named "Phase found" of the type Iteration.
When I look into the data warehouse into the WORKITEMS_SNAPHSOT I cannot find the data field in any of the WC_*_EXT or WS_*_EXT tables.
I found it in the LIVE_SNAPSHOT in the table com.ibm.team.workitem.WorkItem under the data field itemExtensions.

Are the custom fields not recorded in the data warehouse? Or am I searching in the wrong table?

We are running RTC v2.0.0.2 with iFix 6.

Thanks for any help.
Harold.


Hi hal,

For some of my custom reports I used WC_STRING_EXT and in that table you have columns KEY and VAL. When you provide custom attribute id in KEY as a parameter, you can get its value in column VAL.
If you have more than one custom attributes, you can create another one data set, but with other custom attribute id.

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.

Ask a question
Guidelines
FAQ
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

Question asked: Dec 01 '11, 8:41 a.m.

Question was seen: 5,825 times

Last updated: Dec 01 '11, 8:41 a.m.

Confirmation Cancel Confirm