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?

I am actively using the above solution to cleanup from time to time. Why is it not working for you? — Tore Østergaard, Nov 13 '17 at 16:03
@ToreØstergaard yep, i was trying to do this with a browser — USER_8675309, Nov 14 '17 at 20:54

score 7 · Accepted Answer · answered Nov 13 '17 at 17:39

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.

I was trying to use the web version of this, but it was failing. Luckily this version worked perfectly! Thank you — GantTheWanderer, May 24 '18 at 18:38

Close someone else's code review TFS 2015

1 Answers1

Linked