locked
Creating query for pulling parents with ALL child tasks in a given state RRS feed

  • Question

  • Hi,

    I am looking help on creating a query that can bring only parent items that has ALL tasks marked as "Done"

    I was able to get the results, however for parents with multiple tasks, it brings the ones that have some of the tasks open. 

    i am looking for only those parents with ALL tasks marked as "Done"

    Appreciate your help!

    Thanks.

    Monday, November 27, 2017 4:18 PM

All replies

  • Hi L_Gupta,

    To achieve your requirement, you need to use TFS API instead of a query.

    First, you need to get a list of work items with links and attachments, then check the state of the child tasks to see whether they all have been marked as Done:

    https://www.visualstudio.com/en-us/docs/integrate/api/wit/work-items#with-links-and-attachments

    Best regards,


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, November 28, 2017 9:09 AM