cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Announcements
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.
For production deployment issues, please contact the TAC! We will not comment or assist with your TAC case in these forums.
Please see How to Ask the Community for Help for other best practices.

602
Views
5
Helpful
4
Replies
Highlighted
Enthusiast

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

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
VIP Advisor

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. 

 

View solution in original post

4 REPLIES 4
Highlighted
VIP Advisor

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. 

 

View solution in original post

Highlighted

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

 

reports-adv.PNG

 

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?

 

reports-nonadv.png

 

Highlighted

 
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.

Unknown.png

 

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

 

 Unknown2.png

 

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

 

 Unknown3.png

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

Content for Community-Ad