Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Complex Filter - Filter out two different check on same field in multiple OR statements

Avatar

Level 2

Hi,

 

I have a report with 3 level of OR statements. Example below.

Field1_Mod=isnull

name=Task 1

name_Mod=cicontains

OR:1:Field1_Mod=isnull

OR:1:name=Task 2

OR:1:name_Mod=cicontains

OR:2:Field1_Mod=isnull

OR:2:name=Task 3

OR:2:name_Mod=cicontains

 

But on Field 1, I want to do an additional check to exclude the task if FIeld 1 contains 0 in it. 

 

So I modified the code as below:

Field1_Mod=isnull
AND:1:Field1_Mod=cinotcontains

AND:1:Field 1_=0

name=Task 1

name_Mod=cicontains

OR:1:Field1_Mod=isnull

OR:1:name=Task 2

OR:1:name_Mod=cicontains

OR:2:Field1_Mod=isnull

OR:2:name=Task 3

OR:2:name_Mod=cicontains

 

The code works find for Task 1, but I want to apply the same logic for Task 2 and Task 3. 

 

I am not sure how to write the same AND:1: code but for OR:1 and OR:2.

 

Is that even possible?

 

0 Replies