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.
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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.