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):
| Corrected Estimate | Estimate | Maximal Estimate | Minimal Estimate | Time Spent | Consequence Cost |
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
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.