Rolling up time spent in parent/childTasks
We have a situation where we create parent tasks that have multiple children. The issue is that the child tasks do not rollup the time spent to the parent. I believe this functionality is not part of the 1.0 release. What we are looking for is a solution that can provide the information through the workitem, a report, or even the API if needed. The amount of time required to manually rollup the tasks today is significant and not practical.
2 answers
We have a situation where we create parent tasks that have multiple children. The issue is that the child tasks do not rollup the time spent to the parent. I believe this functionality is not part of the 1.0 release. What we are looking for is a solution that can provide the information through the workitem, a report, or even the API if needed. The amount of time required to manually rollup the tasks today is significant and not practical.
I would like to hear other ideas on how to accomplish this but here is my own.
1. You could write an AbstractAutoScheduledTask
It runs periodically on the server.
(see https://jazz.net/wiki/bin/view/Main/QueryDevGuide)
It would query for work items, perhaps a specific type like defects or tasks, and where the time spent attribute has not been set yet.
For each work item, get the child references, if any.
For each child, get the "time spent" attribute.
Calculate the sum of all children for that parent.
Save the result on the parent work item.
I think the hard part is coming up with a correct and efficient query.