Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Get Ennueration LITERAL_NAME in SQL Query

Questions
Tags
Users
Badges
Philippe Preville
(36●2●8●8) 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

0 votes

1 answer
5,330 views
0 votes

One answer

Permanent link
Rafik Jaouani
JAZZ DEVELOPER (5.0k●1●6) 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.

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,943

Question asked: Feb 08 '10, 9:22 a.m.

Question was seen: 5,330 times

Last updated: Feb 08 '10, 9:22 a.m.

Confirmation Cancel Confirm