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

Where in the data warehouse can I find a custom attribute of type contributor?

Questions
Tags
Users
Badges
Fábio Castro
(63●1●12●15) edited
Sep 20 '13, 8:15 p.m.
I'm using RTC version 4.0.2 and I can not find in workitem table of RTC the custom attribute of type contributor.

I tried by string_key in LIVE_WORKITEM_CNT and by stringExtensions.key in com.ibm.team.workitem.WorkItem but I did not find the custom attribute.

Is there anyway to get value of custom attribute of type contributor, or there is a bug in RTC and it is not possible?

0 votes

2 answers
4,213 views
0 votes

Accepted answer

Permanent link
Brian Fleming
(1.6k●1●19●28) Sep 20 '13, 2:57 p.m.
There is a description of how to do this in workitem 184675
Fábio Castro selected this answer as the correct answer

1 vote

One other answer

Permanent link
Abuzaid Shaikh
(89●1●4●6) Sep 22 '13, 8:22 a.m.
 Hi Fabio,

The custom attribute of type contributor is in LIVE_SNAPSHOT table in com.ibm.team.workitem.WorkItem 
the column itemExtensions.key is the id of the attribute and itemExtensions.value is the encrypted value of the user (contributor).

Hope this helps.

Regards,
Abuzaid Shaikh

2 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: Sep 20 '13, 12:27 p.m.

Question was seen: 4,213 times

Last updated: Sep 22 '13, 8:22 a.m.

Confirmation Cancel Confirm