Forum Discussion

Vitec-nOrphf's avatar
Vitec-nOrphf
Copper Contributor
Sep 19, 2022

Queries, "or direct links"

Hi   I have a query setup as "Work items and direct links" with following filters ---------------------------------- Assigned to me State <> Done Work Item Type = Product Backlog Item   Filte...
Azure DevOps
Queries
  • Vitec-nOrphf's avatar
    Vitec-nOrphf
    Sep 20, 2022

    Vitec-nOrphf 

    ----------------------------------

    Assigned to @me

    AND

    State <> Done

    AND

    Group1---------

    Work Item Type = Product Backlog Item

    OR

    Work Item Type = Task

    EndGroup1-----

     

    Filter for link

    Work Item Type = Task

    OR

    GROUP1--------

    Work Item Type = Product Backlog Item

    AND

    Assigned to <> @Me

    EndGroup1-----

     

    Return matching links; Type of links: Childs, Parent

    -----------------------------------------

Vitec-nOrphf's avatar
Vitec-nOrphf
Copper Contributor

Vitec-nOrphf 

 

I might have found a way, but I'm unsure if I get doubles:

----------------------------------

Assigned to @me

AND

State <> Done

AND

Group1---------

Work Item Type = Product Backlog Item

OR

Work Item Type = Task

EndGroup1-----

 

Filter for link

Work Item Type = Task

 

Return all top level; Type of links: Childs

-----------------------------------------

 

EDIT: Yes, I get Tasks assigned to me with a PBI assigned to me, twice

Can I filter on "Parent.AssignedTo" in top level filter?

 

Regards Lars

Vitec-nOrphf's avatar
Vitec-nOrphf
Copper Contributor
Sep 20, 2022

Vitec-nOrphf 

----------------------------------

Assigned to @me

AND

State <> Done

AND

Group1---------

Work Item Type = Product Backlog Item

OR

Work Item Type = Task

EndGroup1-----

 

Filter for link

Work Item Type = Task

OR

GROUP1--------

Work Item Type = Product Backlog Item

AND

Assigned to <> @Me

EndGroup1-----

 

Return matching links; Type of links: Childs, Parent

-----------------------------------------

Share

Resources