Edit Selected Work Items in a Query Result.
You can open a query result in web portal and select the required work items. Then right clicking and click “Edit selected work item(s)”.
![image image](https://lh3.googleusercontent.com/-GxbbSNyuFMA/WJKlgNx2HqI/AAAAAAAAIAA/q72npLMvohQ/image_thumb%25255B2%25255D.png?imgmax=800)
In the popup window select the required field and value. You can edit multiple fields. Click OK when done editing.
![image image](https://lh3.googleusercontent.com/-oYdLUgWno7A/WJKliFKFarI/AAAAAAAAIAI/bvrjEyXYnds/image_thumb%25255B6%25255D.png?imgmax=800)
Save all changes.
![image image](https://lh3.googleusercontent.com/-tuFlRVav9vE/WJKlkyuwuRI/AAAAAAAAIAQ/4mBL1xkTL-M/image_thumb%25255B9%25255D.png?imgmax=800)
Using Excel
You need to have Team tab availability in excel to use Excel to edit TFS work items. If you do not have Team tab in Excel follow the instructions here. To edit work item field in excel it should be available as a column in the query you are using. You can change columns in the query using column options.
Open Selected Work Items in Excel via Visual Studio
![image image](https://lh3.googleusercontent.com/-xQWPZtxGoFM/WJKlml0if5I/AAAAAAAAIAY/tbFVQE9B3S0/image_thumb%25255B12%25255D.png?imgmax=800)
Or you can open a new excel document and in the Team tab click New List. Connect to the team foundation server, team project. In the next popup window select the query to open it in Excel.
![image image](https://lh3.googleusercontent.com/-MxdcRqp6VIs/WJKlojl3H8I/AAAAAAAAIAg/Ot41VJg038w/image_thumb%25255B22%25255D.png?imgmax=800)
![image image](https://lh3.googleusercontent.com/-6nBRLr5Bwf4/WJKlqnA6ohI/AAAAAAAAIAo/fotz-0Ynljw/image_thumb%25255B25%25255D.png?imgmax=800)
Do the changes required. Click Publish in Team Tab of Excel.
![image image](https://lh3.googleusercontent.com/-vhqpOGn7JGs/WJKlstpMiEI/AAAAAAAAIAw/Hv5dAmRCgaI/image_thumb%25255B16%25255D.png?imgmax=800)
Change applied to work items.
![image image](https://lh3.googleusercontent.com/--dsCM6wOp-g/WJKluozByuI/AAAAAAAAIA4/0g7Oqg59jxs/image_thumb%25255B19%25255D.png?imgmax=800)
No comments:
Post a Comment