Search code examples
tfstfs-query

How to return only top level items in TFS query

Using the TFS web interface, I need to compose a query that will return all of the Features in which any User Story or Bug has the Release field set to a particular release, which I can do (see the screen shot) but the trick is: how do I return ONLY the Features and not the child work items as well?

enter image description here

I have tried various permutations of this query to get the results I want. For example, I tired selecting "Return selected link type = Parent" but this had zero effect on the results returned. Any ideas?

After having struggled with this for quite a while I am forced to conclude that this is a failing in TFS. There is no way to return only top level results when the query depends on properties of the linked PBI's.

Solution

  • As pointed out by starain-MSFT and Andy-MSFT in comments above, it is not possible to generate a query which returns ONLY top level items based on conditions within the children of those top level items in the web interface alone, which is what I needed. It is apparently possible to pull a query using a REST API but then, you would not be able to build a dashboard widget using the parsed results.