Bulk modify work items
When you want to change one or more fields in several work items, you can bulk modify. For example, you might want to change the priority of several bugs or reassign several tasks to the same team member.
Use Team Web Access (TWA) to quickly modify one or more fields that will all contain the same value. Use Excel to update multiple fields with different values. If you already work in Microsoft Project, then you can use it to perform bulk updates.
From the Query results page, select the work items you want to modify.
You can craft your query using the query editor or search box.
With work items selected, open the context menu for any selected item, and reassign all of them. By doing this, you can quickly assign them to a member of your team or to another sprint or iteration.
Or, edit all the selected work items at one time. Enter a value for each field that you want to update.
For audit purposes, you can type a description for your bulk update task.
Save all work items that you bulk-modified.
Work items shown in bold text indicate that local changes have not yet been saved to the TFS data store.
You can’t change the work item type of an existing work item. However, you can clone an existing work item and specify a new type. Open the work item you want to change, copy it—including all links—and choose the work item type you want.
The cloned work item is automatically linked to the original work item through a Related link type.
If you clone a work item and change its type to task, the cloned task may not appear on the sprint backlog until you have linked it to a parent backlog item or user story.
If you have a large number of work items whose type you want to change, you can export them using Excel, copy them to a new Excel list, and reimport them by specifying a different work item type. See Bulk add or modify work items with Excel.
A: From the backlog page in web access, use Create Query to create a query with the backlog items. Then, open the query in Excel to bulk modify the backlog. To change priorities, you can use the Backlog Priorities or Stack Rank fields.
A: You can use the following clients to bulk edit links:
Use Excel to edit parent-child or hierarchical links.
Use Project to edit parent-child and predecessor-successor link relationships.
Using TWA, you can map backlog items to portfolio backlog items which creates parent-child links.
Using Team Explorer, you can drag items in a tree query to create or modify parent-child links.
A: Yes. Use witadmin destroywi to permanently remove work items from the database.
A: Review the following topics to learn more:
To understand all the search operators available to you, see Query fields, operators, values, and variables.
To find work items based on keywords in the title or description, see Example work item queries.
To find work items based on keywords in the change history, see Query for work items using the History field.
To find work items based on their linked relationships, see Query for work items.