It's all about the answers!

Ask a question

Report Builder in 6.0 and enumeration lists


Michael Mancini (136239) | 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 (96029) | 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 (136239) | 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.