Creating a parent task filter for a document report

[OmahaOmaha]

Hi all, I trying to figure out how to create a parent task filter for a document report?  I tried using the following but didn't have any luck.

task:parent:name=Custom Parent Task Name
task:parent:name_Mod=cicontains

[ChloeWY]

How are you hoping this filter will work?  It looks like you only want projects to show up if they're a child of a parent task called "Custom Parent Task Name".  Is this correct?

Have you tried Task >> Parent ID Equal in the drop down menu?

[OmahaOmaha]

won't that pull in only one parent task with that name? I used contains because I'm hoping to pull in every parent task in every project with that name.

[ChloeWY]

Ah, okay, try this

parent:name=Gate 1
parent:name_Mod=in

It's showing correct results for me for all tasks that fall under Gate 1 across different projects.

[ChloeWY]

I was using a task report, not a document report.  I tried 

task:parent:name=Gate 1
task:parent:name_Mod=in

for a document report, but I wasn't able to get it to work either

[skyehansen]

Likely to be too many hops.

https://experienceleaguecommunities.adobe.com/t5/custom/page/page-id/GlobalSearch#q=too%20many%20hop...

If you verified the above filter worked in a task report, then copy and paste into a document report with an exists statement.

EXISTS:a:$$OBJCODE=TASK

EXISTS:a:ID=FIELD:taskID

EXISTS:a:YOUR-FILTER-GOES-HERE

so for yours, it would possibly be something like this:

EXISTS:a:$$OBJCODE=TASK

EXISTS:a:ID=FIELD:taskID

EXISTS:a:parent:name=Gate 1
EXISTS:a:parent:name_Mod=in

(in other words, whatever worked in the task report should work if you paste it into the bolded areas in a document report)