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

Question

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?

skyehansen · Accepted Answer

somewhat similar -- except that you need the ":1" in front of ALL the ANDs, just like it is in your first set. And your field name needs to be consistent... whatever it is.

(I should have said "to the right" of all the ANDs, but hopefully you got my drift!)

skyehansen · Answer

if you got task1 working, you should be able to do the same for task2 and 3. Just think of it as creating three different sets of filters, and just adding the "OR:__:" part to the front of each filter set.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded