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

Story Points with Birt Report

Hello,

can somebody tell me in which table of which data source I can find the Story Points.

Thanks
Sandra

0 votes


Accepted answer

Permanent link
Story points are a custom attribute, so you won't find a column called Story Points in any of the tables.  Instead, custom attributes are stored as (key, value) pairs, where the key is the identifier for the attribute.  You will also need to know the type of the story points attribute in your project (e.g. string, integer), since the custom attributes are stored according to type.  You can find the story point data in a couple of different tables, depending on whether you're looking for the live value or the historical data.  For example, in the LIVE_WORKITEM_CNT table, there are columns INTEGER_KEY and INTEGER_VAL.  For historical data, check out the WC_{type}_EXT tables.  You can read more about these tables at this link: You may find this link helpful - https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20.

Sandra Hoffmann selected this answer as the correct answer

0 votes

Comments

Thanks Alanna, this solve my problem.


One other answer

Permanent link
Any update on that?

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.

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,954

Question asked: Feb 07 '13, 10:33 a.m.

Question was seen: 4,353 times

Last updated: Feb 27 '13, 3:24 a.m.

Confirmation Cancel Confirm