CODEWITHSUNDEEP
azure-devops
Tshy
Tshy

Reputation: 21

How to query the initial "Remaining work"

  1. I'm trying to query/summarize the total amount of initial "Remaining work" per person per iteration in azure DevOps. In other words, I want to see the sum of the first initially entered "Remaining work" of all the tasks within an iteration per person.
  2. Because you can change the "Remaining work" I can't see the initial amount of hours of a task, specialy if the task is put on "done" (then it automatically becomes 0). I can manually see the initial "Remaining work" per task in the history part but I can't find a way to put this in a query.

Would be great if someone knows a solution to this.

Thx

Tshy

Upvotes: 1

Views: 2129

Answers (1)

Shamrai Aleksander
Shamrai Aleksander

Reputation: 16018

I think, you have 2 ways and they are not easy:

  1. Use Power Bi to create report and calculate your "Remaining work": Connect to Analytics with Power BI Data Connector
  2. Add the "Original estimate" field to the task work item type (Customize a project using an inherited process). Then update it with first value of the "Remaining work" field through the Rest API: Query work items without value in "Original estimate" and with value in "Remaining work" (Wiql - Query By Wiql) -> Update "Original estimate"(Work Items - Update)

Upvotes: 1

Related Questions