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.
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
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.
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.
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.