Is it possible to filter a task report using a nest task's field from another task in the same project?

[OmahaOmaha]

I want to know if its possible to create a filter on a task report that uses a nested task from the same project?  Ideally the filter would filter out sister tasks of the nested task's field that showed the task not being 100% complete.  If that makes sense.

[Sven-iX]

Hey @OmahaOmaha 

... If that makes sense.

---

Nope not to me (yet). 
What does this mean : "filter out sister tasks of the nested task's field" ?

Would it work to filter out tasks that 

• don't have children
• are not complete

?

[OmahaOmaha]

If the related task ( the one in the report) has a task in the same project (the nested task, non-child being referenced in the filter) is less than 100% complete, then filter out that related task from the report.  I hope that makes sense, kind of hard to explain.

[Sven-iX]

screenshot of your project plan with the tasks you want to see, and the current report filter?

[OmahaOmaha]

Here's my current report filter:

approvalStartDate_Mod=notnull
name=RTC
name_Mod=cicontains
OR:1:approvalStartDate_Mod=notnull
OR:1:name=RTC
OR:1:name_Mod=cicontains
OR:1:pendingApproval=true
OR:1:pendingApproval_Mod=eq
OR:1:project:portfolioID=64a8480200164a16c1a52f4f45488cc2 64b19a4c008abe04fa338f72f6f774df 65bd40f000a93ecbc7ded2e3a9b78954
OR:1:project:portfolioID_Mod=notin
pendingApproval=true
pendingApproval_Mod=eq
project:name=TW_
project:name_Mod=cinotcontains
project:portfolioID=64a8480200164a16c1a52f4f45488cc2 64b19a4c008abe04fa338f72f6f774df 65bd40f000a93ecbc7ded2e3a9b78954
project:portfolioID_Mod=notin

[Sven-iX · Accepted solution]

I don't understand the filter: 2 blocks are identical except the first block further excludes projects whose name contains "TW_". 

So just that block (the non-OR block) gives determines the result set. Am I missing something? 
No idea how Green Light and Request Title Code tasks are related or which one you want to exclude.  Also don't understand the blank task names? Moreover, how can the greenlight be complete if the prepping for it, and all the other tasks before it, are incomplete? 

So I'm going to guess. You have a report with greenlight tasks. And you don't want a greenlight task to show if one of the upstream tasks is incomplete. My suggestion is to properly use predecessors so that you can use the greenlight's "isready" field for reporting/filtering.