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

Enumeration field does not appear in RRDI Reports

Questions
Tags
Users
Badges
Arvind Garg
(10●2●2) Aug 18 '14, 5:00 p.m.
I have a enumeration field defined in CLM. I want to create a report using this field.

This field has been populated correctly in CLM GUI. But i am not able to find in reporting database.

Any help on this issue ?

Arvind

0 votes

3 answers
6,281 views
0 votes

Accepted answer

Permanent link
Francesco Chiossi
(5.7k●1●11●19) Aug 19 '14, 10:26 a.m.
Hello Arvind,

you can create a join like this:

Best Regards,

Francesco Chiossi
Arvind Garg selected this answer as the correct answer

0 votes

Comments
Arvind Garg
Aug 20 '14, 9:19 a.m.

Thanks Francesco for your prompt replies.

2 other answers

Permanent link
Francesco Chiossi
(5.7k●1●11●19) edited
Aug 19 '14, 4:43 a.m.
Hello Arvind,

for work items enumerations you should look into
Operational Data Store > Request Area > Request Enumeration

for requirement enumerations you should look into
Operational Data Store > Requirement Area > Requirement Enumeration Extension

Best Regards,

Francesco Chiossi

0 votes

Comments
Arvind Garg
Aug 19 '14, 7:29 a.m.

Thanks Francesco .
We have Team name enumeration defined in CLM. I can see those names in Request Enumeration table. All requests go to REQUEST HISTORY table. I am not finding any way to connect a request to its assigned team. Can it be CLM configuration issue ?

Permanent link
Francesco Chiossi
(5.7k●1●11●19) Aug 19 '14, 7:36 a.m.
Hello Arvind,

if the enumeration is used in a custom attribute of a Work Item, the relation should appear in one of the Request [Data Type] Extension table.
For example Request String Extension, there the enumeration value will be represented with the ID used in the process template.
You have to perform a join with Request Enumeration to get the literal value.

Best Regards,

Francesco Chiossi

0 votes

Comments
Arvind Garg
Aug 19 '14, 9:12 a.m.

Thanks for your input.
To get a team name . I need to connect  below two columns. These columns are varchar.
I can not find any integer column. is this the only way ?

[Business View].[Request String Extension].[Value]

[Business View].[Request Enumeration].[External ID]


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: Aug 18 '14, 5:00 p.m.

Question was seen: 6,281 times

Last updated: Aug 20 '14, 9:19 a.m.

Confirmation Cancel Confirm