It's all about the answers!

Ask a question

Displaying RTC workitems with Enumerations


Nataliya Kisina (862115) | asked Feb 22 '12, 3:34 p.m.
Hello All,

I am using Insight 1.0.1.1 with RTC 3.0.1. I need to display a list of all workitems with all their related custom enumerations. Sounds not too hard, but I cannot find that data.
I can find the Workitmes (Request table). I can find enumerations (Enumeration table). However when I join two of them together I get 0 rows which means that the linkage is not set up.
What am I missing? How can I find out which enumeration is connected to which workitem and what value is selected?
I went to XDC file and looked through every field available for workitem field, and I do not see anything that would be related to enumeration....

Please help.

Thank you!!!!

Nataliya

3 answers



permanent link
Jared Russell (1.3k12019) | answered Feb 23 '12, 9:27 a.m.
All custom enumeration attribute values are stored in the Request String Extensions table, where the value in the extension table is the literal id from the process configuration. In order to get the display name of the enumeration value, you need to join the string extension value with one of the id columns in the Request Enumeration query subject (exact column name escapes me).


Hello All,

I am using Insight 1.0.1.1 with RTC 3.0.1. I need to display a list of all workitems with all their related custom enumerations. Sounds not too hard, but I cannot find that data.
I can find the Workitmes (Request table). I can find enumerations (Enumeration table). However when I join two of them together I get 0 rows which means that the linkage is not set up.
What am I missing? How can I find out which enumeration is connected to which workitem and what value is selected?
I went to XDC file and looked through every field available for workitem field, and I do not see anything that would be related to enumeration....

Please help.

Thank you!!!!

Nataliya

permanent link
wei zhang (2011) | answered Feb 23 '12, 9:50 p.m.
JAZZ DEVELOPER
First, we must confirm which way you want to extract data from RTC, database or rest service? With your statements, I guess you want to extract data from RTC repository database directly. If it is, this is not the official support way because of its tight coupling, but I also have detail information to resolve it. For security reason, I couldn't answer it here, but you could directly connect me by IBM internal if you wish.

By rest service, you could download XDC files from CLM server directly. In these XDC files, you will find how to get customer attributes. It's the officially support customer attributes extracting.

Hello All,

I am using Insight 1.0.1.1 with RTC 3.0.1. I need to display a list of all workitems with all their related custom enumerations. Sounds not too hard, but I cannot find that data.
I can find the Workitmes (Request table). I can find enumerations (Enumeration table). However when I join two of them together I get 0 rows which means that the linkage is not set up.
What am I missing? How can I find out which enumeration is connected to which workitem and what value is selected?
I went to XDC file and looked through every field available for workitem field, and I do not see anything that would be related to enumeration....

Please help.

Thank you!!!!

Nataliya

permanent link
Nataliya Kisina (862115) | answered Mar 20 '12, 11:51 a.m.
Thank you!!!
We were able to resolve this by manually setting up joints in the Report Studio.

Comments
Swathi Nulu commented Aug 13 '12, 6:47 a.m.

Hi ,

Can u please let us know the process ..How you achieved the above problem through Joins by using Report Studio .We are also working on same requirement .

Thank You In Advance

With Regards, Swathi N

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.