SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Multiple Tagging of TFS Work Items Using Excel

In my article, TFS tools for managing SQL Server development, I covered several Team Foundation Server (TFS) client tools that can be used to manage SQL Server-related development. Some of the feedback I received from the article was the issue of tagging items in Excel. This article illustrates how TFS work items can be multi-tagged using Microsoft Excel.

Understanding TFS Tagging

The usage of tags in TFS is no different to other platforms whereby tags are used for providing additional metadata about a given item. In TFS, tags can provide an additional mechanism for searching and retrieval of related items. The default list columns in Excel does not include Tags – for that to happen, you will have to click Choose Columns and include the Tags column as part of the selected columns that you may want to view, as shown below:


After, I added the Tags column, I then tagged my task as SQL Server, as shown below:


Below image shows how my task looks like in the Web Access view of TFS. You can already notice the highlighted SQL Server tag.


So what if you want to add multiple tags against the same TFS work item? Well, the key to multiple tagging is separating your tags with a semi-column. Below image, show that in addition to SQL Server, I have added T-SQL and DB as new tags.


Once you have committed your changes (by clicking the Publish button), your tags will immediately get rearranged in an alphabetically order as shown below.


Finally, when we refresh our Web Access view, we can now see all our tags against our task number 499.




That’s all, folks. Till next time.



Select SIFISO Blogs

Sifiso W. Ndlovu is a certified Microsoft professional who holds a Master’s degree in IT Management from the University of Johannesburg. He specializes on a range of enterprise and consumer technologies using open source and proprietary software. He is the member of the Johannesburg SQL User Group wherein he has made several presentations on User Group Meetings and SQL Saturday sessions. He has written for a number of publications including SQLShack.com and SQLServerCentral.com.


Leave a comment on the original post [blogs.selectsifiso.com, opens in a new window]

Loading comments...