More information on "Story child work items"
![]()
Can someone give me a few pointers as to how this report actually works ?
I can see it is using two datasets into the WORKITEMS_SNAPSHORT->LIVE_WORKITEM_CNT table, but how does it link them together. I guess what I'm really asking is how a parent->child relationship is represented in the database ? Is there an ERD anywhere for the database ? Thanks, Martin. |
3 answers
![]()
You can check the following video for an example:
http://jazz.net/library/video/285 For a list of all RTC tables that are exposed to BIRT, check the following WIKI for RTC 2.0: https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20 Rafik Jaouani Developer (Reports Team) |
![]()
The video does cover this - but it goes through a lot of concepts very quickly and in a few places - there is stuff going on that is outside of the viewable screen. Is any of this in a document somewhere so that you can follow it whilst writing a similar report ?
What I did gather is that we use the links table to link between the work items. Is there a list of the common link types anywhere ? Things such as parent, child, duplicate, blocked by etc. ? The wiki article is useful. It would help if there was a diagram and maybe some examples showing some real data and how it is represented in the database itself. Thanks, Martin. |
![]()
Martin, you can download the tutorial report design from:
https://jazz.net/wiki/bin/view/Main/ReportsCentral#Links Sorry for the videos going so fast. They had to fit within the ten minute limit of youtube. To discover the link types in the system do the following: Create a data set on the LINKS table and select the LINK_TYPE column only. Make sure the data set is of type: parameter data set. So you do not get duplicates. Preview the data set and that will give you all the link types in the system. |
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.