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.
2 answers
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