It's all about the answers!

Ask a question

Reports: custom enumeration fields on reports (RTC 1.0.1.1)


Claudia Callegari (44449871) | asked Sep 04 '09, 3:51 p.m.
Is it possible to retrieve a custom enumeration field value to be shown on a report?
I am able to retrieve the literal ID (using string_key and string_value), but cannot find where that enumeration is defined to get the friendly name of that literal id.
In 2.0 I have an ENUMERATIONS table, but not in 1.0.1.1

Ideas?
Thanks

Claudia

3 answers



permanent link
Rafik Jaouani (5.0k16) | answered Sep 04 '09, 9:07 p.m.
JAZZ DEVELOPER
No, the data is not available to reports in 1.0.1.1. You would have to hard code the mapping in your report design.

permanent link
Claudia Callegari (44449871) | answered Sep 09 '09, 2:37 p.m.
Thanks Rafik.
And how many fields (non enum) can I retrieve at the same time using string_key and string_value on a report? Am I wrong if I say that only 1 field at a time?
Thanks
Claudia

permanent link
Rafik Jaouani (5.0k16) | answered Sep 09 '09, 3:59 p.m.
JAZZ DEVELOPER
You can retrieve each custom field in its own data set, collect all the data in one javascript array (in the onFetch method). Then create a scripted data set from the array. And voila, you have everything in one data set. Avoid using BIRT's joint data set which can only join two tables.

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.