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

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

Questions
Tags
Users
Badges
Ian Wark
(797●1●35●53) 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

0 votes

3 answers
5,976 views
0 votes

Accepted answer

Permanent link
Bill Taylor
(144●15●35) 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

0 votes

2 other answers

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


1 vote

Permanent link
Indradri Basu
(1.8k●1●5●14) 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)

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
× 324

Question asked: May 03 '13, 3:47 a.m.

Question was seen: 5,976 times

Last updated: May 08 '13, 10:19 p.m.

Confirmation Cancel Confirm