Query VSTS for all PBI's with no open tasks

Question

I would like to be able to create a query in VSTS that will return a list of PBI's (from a specific sprint/area) where all tasks are "Done".

It this possible? From what I can see around SO this requires using the REST API of VSTS.

Would I be able to create a chart in a dashboard with a hierarchy list?

Thanks :-)

Answer 1

You should be able to do this, although you will also get the tasks returned, but you should be able to easily filter those out depending on what you are trying to do.

Use the following Steps:

1. Queries -> New Query
2. Type of query -> Work Items and Direct Links
3. Filters for top level work items -> set this to the type of work items you are using, in my example I am using 'User Story'. Add additional path/iteration filters that you require
4. Filters for linked work items -> Set work Item Type = Task and State = Closed
5. Filter Options -> Only Return Items that have matching links