It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,880
×324
×52

question asked: May 03 '13, 3:47 a.m.
question was seen: 4,514 times
last updated: May 08 '13, 10:19 p.m.

Related questions

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

0
Ian Wark (797●1●35●53) | 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

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

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Sandy Grewal (1.6k●12●23) | 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


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

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.