Let’s start with a screen you’re already familiar with if you use TFS. This is just a standard work item query that displays all of the features in the current project.<\/p>\n
Now, let’s extend the query into a “Tree” query to show how the features have been broken down into tasks and subtasks. Do this by clicking “Query on links” and selecting “Tree” in the combo box that appears.<\/p>\n Now let’s find all of our requirements and the test cases that test them. This time I’ve chosen “Must have” for the type of link query and I’ve filtered the linked items to test cases. This means show all requirements that have any links to test cases and the test cases they are linked to.<\/p>\n But what about requirements that don’t have any test cases? That’s pretty easy too. Just change the link query type combo box again to “Must not have” and you get the list of Requirements that do not have any associated test cases – and now you can go add them \ud83d\ude42<\/p>\n Let’s view one of our requirements. Look at the links tab now. It is categorized by link type to make managing links much easier.<\/p>\n Another new feature of the links control is that it can be filtered and can display column values from the target work item. Here’s a snippet from the Description tab on the same requirement.<\/p>\n Here’s another example from the Tested By tab.<\/p>\n We’ve been exploring a few different kinds of links above – Child, Tested By, Fulfills. But, as I mentioned, the set of link types is extensible and we’ve included quite a few out of the box. Here’s what the link creation dialog looks like.<\/p>\n <\/p>\n Entering lots of work items and manually linking them up can be cumbersome. Excel makes for a fantastic tool for doing this. We’ve extended our Excel support to enable hierarchies. You get the full power of grid\/list editing of Excel and the ease of creating heirarchies by just using indented columns. You can launch Excel to do work breakdown by right clicking on a query in the Team Explorer and selecting “Open in Microsoft Excel (Tree List)”. The result will look something like this…<\/p>\n![](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image05.png\")
<\/a> <\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n