How to get iteration path or iteration id in TFS API?

Question

I am trying to complete the tasks of a specific iteration. I know that I can get this using the iterative path or Iterative identifier. I have this query:

SELECT * 
  FROM WorkItems
  WHERE [System.WorkItemType] = 'Task'
    AND [System.IterationID] = 24138

The request works fine, but I have no way to get this iteration path or Iterative identifier.

Is there a way to get the iteration id?

Answer 1

You will need to query the tables from the Tfs_Warehouse database. Here you can find the link here . The request is as follows:

SELECT * from DimWorkItem dwi
INNER JOIN DimIteration di on dwi.IterationSK=di.IterationSK
WHERE dwi.System_WorkItemType = 'Task'
AND di.IterationPath = 'foobar'