In TFS query builder, I would like to build a query to get all PBIs historical state changes together with the date when that change occured. For instance :
PBI : User Story 1 History
PBI : User Story 2 History . . .
Basicly I want the History tab of each PBI shown in a list.
There is no this kind of workitem query directly return what you need.
Since you need the specific dates/times on which state transitions occurred. You should use TFS API to get the workitem history, and enumerating through the revision history of the work item to get the state transition history. More details please take a look at this useful article here: TFS SDK: Work Item History Visualizer using TFS API
