CODEWITHSUNDEEP
tfstfs-2015
kapz
kapz

Reputation: 457

Get User Stories with more than 5 Bugs in TFS

I want to select user stories with more than 5 bugs as children. Using below query I can get user stories with at least one bug but filtering out the ones with less than 5 I'm lost.

enter image description here

How can I do this? Or is there any other way I can get this output? i.e: TFS extension

Upvotes: 1

Views: 348

Answers (2)

PatrickLu-MSFT
PatrickLu-MSFT

Reputation: 51093

There is no build-in feature to count/filter linked work item's count of a specific work item type.

As a workaround, you could export tfs query results to Excel and manage the results in excel side. With the help of excel, you should be able to filter out those work items you needs.

Another way is using TFS API to get the work items and their linked work items with bug type, finally count the number of linked work items. About how to use API, please take a look at this related question: Retrieving work items and their linked work items in a single query using the TFS APIs

Upvotes: 1

Shayki Abramczyk
Shayki Abramczyk

Reputation: 41575

You can use in the query in "Related Link Count" field:

enter image description here

Upvotes: 0

Related Questions