Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Query to get all items assigned to me in a tree with all parents (of all levels)

I'm trying to create a query that give me a list of all my assigned items + all parents (until root parent).

Assume following items in tfs:

- Feature 1
-- Product Back Log Item 1-1
--- Task 1-1-1
--- Task 1-1-2 (assigned to me)
--- Task 1-1-3
-- Product Back Log Item 1-2
--- Task 1-2-1 (assigned to me)
--- Task 1-2-2
--- Task 1-2-3
-- Product Back Log Item 1-3
--- Task 1-3-1
--- Task 1-3-2
--- Task 1-3-3
- Feature 2
-- Product Back Log Item 2-1
--- Task 2-1-1
--- Task 2-1-2
--- Task 2-1-3
- Feature 3
-- Product Back Log Item 3-1
--- Task 3-1-1
--- Task 3-1-2
--- Task 3-1-3 (assigned to me)

How can i write a query that results me following output:

- Feature 1
-- Product Back Log Item 1-1
--- Task 1-1-2 (assigned to me)
-- Product Back Log Item 1-2
--- Task 1-2-1 (assigned to me)
- Feature 3
-- Product Back Log Item 3-1
--- Task 3-1-3 (assigned to me)

Is this possible in Visual Studio Team Services?

like image 945
Daniel C. Avatar asked Oct 07 '16 06:10

Daniel C.


1 Answers

That is not too hard to do. Create a new query, set the type to "Tree of Workitems" and set the Child filter to include assigned to=@me. Set the drop down on the bottom right to: "match linked work item first".

enter image description here

like image 185
jessehouwing Avatar answered Sep 20 '22 23:09

jessehouwing