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.

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

Thanks for your help,


One answer

permanent link
Rafik Jaouani (5.0k16) | answered Feb 25 '10, 11:06 p.m.
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.

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.