It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×11,924
×475
×228
×180
×46

question asked: May 19 '17, 3:44 p.m.
question was seen: 2,881 times
last updated: May 24 '17, 11:09 a.m.

Related questions

FAQ - How this Forum works

Report Builder in 6.0 and enumeration lists

0
Michael Mancini (136●24●10) | asked May 19 '17, 3:44 p.m.

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. 

2 answers

Most liked answers|Newest answers|Oldest answers ↑

0
permanent link
Kenji Sarai (960●2●9) | answered May 19 '17, 9:22 p.m.

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
permanent link
Michael Mancini (136●24●10) | answered May 24 '17, 11:09 a.m.

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

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.