It's all about the answers!

Ask a question

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

Fábio Castro (6311215) | asked Sep 20 '13, 12:27 p.m.
edited Sep 20 '13, 8:15 p.m. by Geoffrey Clemm (30.1k33035)
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 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

permanent link
Brian Fleming (1.6k11928) | 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

permanent link
Abuzaid Shaikh (89146) | answered Sep 22 '13, 8:22 a.m.
 Hi Fabio,

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

Hope this helps.

Abuzaid Shaikh

Your answer

Register or to post your answer.