Forum Discussion

pradip10's avatar
pradip10
Copper Contributor
Aug 22, 2022

Can I query the child of child work items and publish them on a board?

Can I query the child-of-child work items and publish them on a dashboard.

For example in the below structure, how can I query all the user stories for an Epic

Epic

 |_Feature1

      |_User Story1

      |_User Story2

 |_Feature2

      |_User Story1

azure devops

1 Reply

Sort By
  • new_ways_of_working's avatar
    new_ways_of_working
    Copper Contributor
    Aug 23, 2022

    pradip10  - In short, No.
    While it's possible to get such results using hierarchical query, the dashboard widgets only work with flat result sets 😞


    I find the following workaround a useful coping technique:

    - Write query 1 to find the children (Features) of the Epic.   Use: Parent = Epic ID. 

    - Write query 2 to find the children (Items) of those Features.   Use: Parent "in" list of Feature IDs (comma separated).

    - Then use Query 2 with the chart/analytics Widgets on a Dashboard to represent the query result set however you wish.

Resources