• Home
        • Database Development

          Database development is designing, creating a database or data model, and analyzing requirements and their intents as raw data.

          Learn More
        • Architecture & Design

          Software architecture refers to the fundamental structures of a software system and the discipline of creating such structures and systems.

          Learn More
        • Programming

          Computer programming is the process of performing a particular computation or more generally, accomplishing a specific result.

          Learn More
        • Cloud Computing

          Cloud computing is the on-demand availability of computer system resources, especially data storage and computing power.

          Learn More
        • ETL Development

          ETL provides the foundation for data analytics and machine learning workstreams. Through a series of business rules, ETL cleanses and organizes data.

          Learn More
        • Data Visualization & Reports

          Data and information visualization is an interdisciplinary field that deals with the graphic representation of data and information.

          Learn More
  • Blog
  • Contact

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:
"tags1"
After, I added the Tags column, I then tagged my task as SQL Server, as shown below:
"tags2"
Below image shows how my task looks like in the Web Access view of TFS. You can already notice the highlighted SQL Server tag.
"tags3"
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.
"tags4"
Once you have committed your changes (by clicking the Publish button), your tags will immediately get rearranged in an alphabetically order as shown below.
"tags6"
Finally, when we refresh our Web Access view, we can now see all our tags against our task number 499.
"tags5"

Conclusion
That’s all, folks. Till next time.
Cheers,
Sifiso.
CodeProject

Loading

Sifiso

October 13, 2022
Sifiso is Data Architect and Technical Lead at SELECT SIFISO – a technology consulting firm focusing on cloud migrations, data ingestion, DevOps, reporting and analytics. Sifiso has over 15 years of across private and public business sectors, helping businesses implement Microsoft, AWS and open-source technology solutions. He is the member of the Johannesburg SQL User Group and also hold a Master’s Degree in MCom IT Management from the University of Johannesburg.

Meet Our Experts

We are proud to have a team of experts who are passionate about delivering the best possible solutions to you. Our team members are highly skilled and experienced in a diverse range of IT technologies, and are committed to staying up-to-date with the latest industry trends and best practices to deliver you the best results.

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Join Our Newsletter

Subscribe to get our latest and best thinking on the most definitive workforce topics affecting HR leaders and organizations today.