Expand my Community achievements bar.

Creating a parent task filter for a document report

Avatar

Level 3

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

5 Replies

Avatar

Level 7

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?

Avatar

Level 3

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.

 

Avatar

Level 7

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.

Avatar

Level 7

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

Avatar

Community Advisor

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)