I need a TFS Query to get EPICs in closed state but with any of the related Feature or User Story or Task not closed. Even it should work if Feature closed but User story or Task not closed. User story closed but task not closed.
Can it be done with a single TFS Query in TFS 2013?
I am able to Get Features closed with User story not closed (or) User story closed but Task still not closed through TFS query.
Can I do above EPIC (Closed) -> Feature (<> Closed) -> User Story (<>Closed) -> Task (<>Closed) in single TFS query?
I am able to get the data using below Query.
Used 'Work Items and direct links' type Query.
Top level work items: Work Item Type 'In' Feature,User Story AND Area & Iteration path. AND State = Closed
Filters for linked Work items: Work Item Type 'In' User Story,Task AND State <> Closed
Filter options: Only return items that have matching links Return selected link types: Child
I am able to achieve data for Feature (Closed) -> User Story (<>Closed) -> or Task (<>Closed) & User Story(Closed) but Task (<>Closed) & Feature(Any status).
Will try to use for more levels.