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 help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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?
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Likely to be too many hops.
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)
Views
Replies
Total Likes
Views
Likes
Replies