cancel
Showing results for
Did you mean:
cancel
Announcements
 June 16: Announcing ISE 2.7 as Recommended Release February 27: ISE Awarded Best NAC Solution in the SC 2020 Awards Register for the monthly ISE Webinars to learn about ISE configuration and deployment.
Choose one of the topics below to view our ISE Resources to help you on your journey with ISE

This community is for technical, feature, configuration and deployment questions.
Please see How to Ask the Community for Help for other best practices.

602
Views
5
4
Replies
Highlighted
Enthusiast

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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.

4 REPLIES 4
Highlighted

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.

Highlighted
Enthusiast

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!

Highlighted

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?

Highlighted
Enthusiast

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.