SOLVED

Queries, "or direct links"

Copper Contributor

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

2 Replies

@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

best response confirmed by Vitec-nOrphf (Copper Contributor)
Solution

@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

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

1 best response

Accepted Solutions
best response confirmed by Vitec-nOrphf (Copper Contributor)
Solution

@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

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

View solution in original post