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

Report Builder in 6.0 and enumeration lists

When creating a work item report in Report Builder, attributes that are "enumeration lists" (multi-select) display their literal ID's rather than their named values.


Is there a way to display the values by editing the advanced sections SQL query? If so, where is this information stored? If not, is this corrected in a future release? 

Thank you. 

0 votes



2 answers

Permanent link

Hi Michael,

I have not seen the problem you reported.. but if you are willing to edit the SQL query in Advanced section, RICALM.REQUEST_ENUMERATION table is the one you are after. Check LITERAL_NAME and other values such as

select ENUMERATION_NAME, LITERAL_NAME, EXTERNAL_ID from RICALM.REQUEST_ENUMERATION

 

0 votes


Permanent link

 Thank you Kenji. I found that this is resolved in 6.0.2+. 

0 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.

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
× 12,016
× 481
× 230

Question asked: May 19 '17, 3:44 p.m.

Question was seen: 3,539 times

Last updated: May 24 '17, 11:09 a.m.

Confirmation Cancel Confirm