- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2020 03:12 AM
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
Solved! Go to Solution.
- Labels:
-
AAA
-
Identity Services Engine (ISE)
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2020 03:46 AM - edited 04-28-2020 04:06 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2020 03:46 AM - edited 04-28-2020 04:06 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2020 07:27 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2020 05:32 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2020 04:43 AM
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.
