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

 

Filter for link

Work Item Type = Task

 

Only return matching Childs

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

 

Works exactly as expected. But if I have a task assigned, where I am not assigned to the PBI it will not show.

So I would linke something like

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

Top level filter:

or Work Item Type = Task

And parrent = PBI

 

Linked filter

NONE

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

 

Hope that somone can help me in the right direction

 

Regards Lars Mortensen

  • 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

      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

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

Resources