index > Team Foundation Server - Reporting > Simple query to find work items resolved in the latest build

Simple query to find work items resolved in the latest build

I am trying to create a simple query. What I'd like is to see the list of work items (tasks) that were set to a state of 'Closed' in the latest build that was run - this could be an automated build or one that I kick off manually.

It seemed pretty straightforward to create such a query BUT the query grid does NOT have a 'Resolved In' field. It does have a 'Found In' field so this is a little confusing.

Any ideas how I can get hold of this data. This is the 'Associated Changesets' that is found at the end of the build log. I don't want to have users combing through the whole build log, which is why I am trying to implement this.

DQM

The Work Items have a field "Integration Build". This field is set by the build system if an associated changeset in that build is resolving that bug. So the bug state will be changed from Active to Resolved and this field will be set to the build number.

I'm not sure if this is what you need because it seems you want the bugs that were closed in a build. The system doesn't automatically close bugs and that is more like a manual process and out of the box there is not field that can be set as the "Closed In" build but the work item type can be customized to add that one.

Thanks.

Federico

Federico Kolliker Frers - MSFT

Ok, I now see that Tasks have the value 'Integration Build'. So that will work.

What I was looking for was to include bugs as well. And in the Bug 'Details' tab you can see the 'Resolved in Build' dropdown. This is what I want to include as well when I create a query. This field is not even present in the available fields to query.

DQM

I agree that this is going to sound confusing but the friendly name you see in the Work Item Form (in this case "Resolved in Build" for Bug and "Integration build" for Task) are actually populating the same field "Integration Build".

So, for instance, if you created a Work Item Query in your IDE and you query on Tasks and Bugs and you add "Integration Build" as one of the columns in the Query Results you will see that Tasks and Bugs both show the correct value.

Federico Kolliker Frers - MSFT

reply 4