Get Ennueration LITERAL_NAME in SQL Query
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
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. |