Close someone else's code review TFS 2015

Question

I am in charge of a team of developers that has experienced a high rate of turnover. I have 100 some code reviews in "requested" status because the developer didn't close them before leaving the company. I took ownership of these in TFS by right clicking and assigning to myself, but it is not giving me the option of closing.

According to this link I should be able to download an excel sheet and do a "bulk" update:

Please try this workaround: create a work query to get all that user’s Code Review Request work items which in Requested state, save this work item query and open this query in Excel, then edit them work items in Excel to change the state to Closed, then click Publish button to publish the updates to TFS Server.

I do not see any way to do this either.

What are my options here?

Answer 1

All code review requests are in fact a TFS work item. You can close them in bulk by bulk updating them using Excel, just as you would do for any other work item.

The way to do is to open your code reviews query from the link on the top right of Code Reviews section in Team Explorer

Once you are in query mode, click on "Save query" to save your code review query. Now click on the "Open query in Excel" button

This would open up an excel sheet for you. Change the State of each of code review work item that you would like to update. Then click on the the Team menu and use the "Publish" button to make your changes in TFS.