It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×94
×68
×11

question asked: Sep 20 '13, 12:27 p.m.
question was seen: 3,661 times
last updated: Sep 22 '13, 8:22 a.m.

Related questions

FAQ - How this Forum works

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

0
Fábio Castro (63●1●12●15) | asked Sep 20 '13, 12:27 p.m.
edited Sep 20 '13, 8:15 p.m. by Geoffrey Clemm (30.1k●3●30●35)
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?

Accepted answer

1
permanent link
Brian Fleming (1.6k●1●19●28) | answered 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

One other answer

Most liked answers ↓|Newest answers|Oldest answers

2
permanent link
Abuzaid Shaikh (89●1●4●6) | answered 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

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.