Search code examples
azure-devops-server

Create query in Azure Devops server filtering on User Stories or tasks

I'm struggling to create a query to filter on either the parent user story or the nested child task but I can't figure out if this is possible.

For example:

There is a user story assigned to user A with tasks assigned to User B and C There is another user story assigned to user C with tasks assigned to user A, B and C. Is there a way to create a query which returns both of the user stories and all of their tasks when filtering on user A? I also like the hierarchy to be right, ie the user stories should contain tasks as links.

Solution

  • As a workaround, check the pic below:

    enter image description here

    Note: If the task assigned to user A, the parent-child relationship that returns the result is the opposite

    Update1

    We cannot get the result in the one query, we need to create different queries to get results.

    Task assign to A

    enter image description here

    User Story assign to A.

    enter image description here

    Update2

    Install the extension Query Based Boards->create query->save the query and click the tab Show as Taskboard, then we could see the result.