It's all about the answers!

Ask a question

Get Ennueration LITERAL_NAME in SQL Query


Philippe Preville (36288) | asked Feb 08 '10, 9:22 a.m.
Hello,

I know I can get LITERAL_NAME from WORK_ITEM_SNAPSHOT.ENUMERATION Table, but it only appear in birt, need to have the same info with an SQL Query. There is no such table in jazz db schema (Live or Snap). Can someone knows how to do this ??!

We are running RTC 2.0.0.2.

Thanks for your help,

Philippe

One answer



permanent link
Rafik Jaouani (5.0k16) | answered Feb 25 '10, 11:06 p.m.
JAZZ DEVELOPER
The enumerations are defined inside the process specification which is stored in xml format.

WORK_ITEM_SNAPSHOT.ENUMERATION is not a real database table. The BIRT Jazz Data Source makes it look like a database table.

Your answer


Register or to post your answer.