It's all about the answers!

Ask a question

What Jazz data source snapshot and table can we find these attributes?


Ian Wark (79713450) | asked May 03 '13, 3:47 a.m.
We would like create a BIRT report listing workitem types. We are looking for the workitem ID and workitem name as per the below screen capture.

Could you tell us in what snapshot and table in Jazz data source we can find these attributes?

Attributes we would like to report on

Accepted answer


permanent link
Bill Taylor (1441533) | answered May 03 '13, 4:28 a.m.
Table "TYPE" in "WORKITEM_SNAPSHOT" has these attributes.

WI_TYPE holds the name
TYPE_ID holds the id, but this is prefixed by the 23-character Project Area itemId and the single character 't'.
Ian Wark selected this answer as the correct answer

2 other answers



permanent link
Indradri Basu (1.8k1514) | answered May 03 '13, 4:44 a.m.
If I understand your question correctly, if you create a "Jazz Advanced Data Set", look for WI_TYPE and PROJECT_AREA_NAME in tables like TYPE, LIVE_WORKITEM_CNT, WORKITEMS (not sure if these are there in any others)

permanent link
Sandy Grewal (1.6k1223) | answered May 08 '13, 10:19 p.m.
JAZZ DEVELOPER
@Ian check the following link with the Snapshot details:
https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20


Your answer


Register or to post your answer.