Report Builder in 6.0 and enumeration lists

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

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

It's all about the answers!

Related questions

Report Builder in 6.0 and enumeration lists

2 answers

Your answer