It's all about the answers!

Ask a question

Report Builder in 6.0 and enumeration lists


Michael Mancini (1362410) | 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



permanent link
Kenji Sarai (96039) | 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

 


permanent link
Michael Mancini (1362410) | 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.