ISE 2.6. - Report Advanced filter issue using Does not Contain and 'or' statement

[joshhunter]

Hello, I'm having an issue with Advanced Filter when using does not contain and 'or' statement.

ISE 2.6, Patch 5.

WORKING = Contains: josh or mark 

NOT WORKING = Does not contain: josh or mark 

Similar issue with numbers 

WORKING =  Contains 8971

NOT WORKING = Does not Contain 8971

Any ideas?

Thanks

[Arne Bier · Accepted solution]

If I recall from Boolean logic, there is the following rule:

NOT ( A || B)  Is equivalent to (NOT A && NOT B)

So you are testing NOT A AND NOT B which in your case can never be true unless A==B

Try using an AND instead of an OR 

NOT A Or NOT B is equivalent to NOT (A AND B)

This is called DeMorgan’s Law. 

I stand to be corrected. 

[joshhunter]

Thanks Arne, AND is not available only OR. However, you can use multiple lines as below.

Could you please explain this last query?

With numeric strings, the example still fails! Wondering if searching for alpha strings is ok and numeric strings cause this behavior?

If I search using a partial match though, I get the right output!

[Arne Bier]

Hi

For some weird reason I can't see the images you've put in your posts.

The Reports Advanced filter contains an overall "Any" (OR) or "All" (AND) when compiling a list of conditions

if you don't use Advanced filter, then you have the option of creating other types of queries using some fancy pattern matching and OR operators. Does this help at all?

[joshhunter]

I’ve patched ISE (2.6 patch7) recently, so I ran a few reports to see if things look any better.  I ran a simple query.

But if I scroll through the results, I see the identity I’m trying to filter out.

 

Changing the query from ‘does not equal’ to ‘does not contain’ makes no difference I get the same incorrect data returned

 

Running filters for identities that are not numeric behave as expected and return the correct results.