query to match Work Hours Done in plan hover
I am trying to create an RTC query that will provide Time Spent or Work Done to match the Progress Report hover in the Plan Detail section of a Plan. The Hover indicates Work hours done: 220 of 220. I cannot get to that number using any of the following columns (or combinations there of):
Background: this is a traditional project plan and the work items are on a Closed or Resolved status. Any help would be greatly appreciated. |
One answer
Ralph Schoon (62.0k●3●36●43)
| answered Sep 01 '14, 11:53 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
This data is not available as attribute. This is a presentation that is dynamically computed as far as I can tell. You would basically have to query work items and then iterate their hierarchy to collect the data. https://rsjazz.wordpress.com/2012/07/31/rtc-update-parent-duration-estimation-and-effort-participant/ explains a different approach to calculate data like this.
|