# NOT operator not working?

**URL:** <https://discourse.devontechnologies.com/t/not-operator-not-working/18121>\
**Category:** Tips\
**Created:** [December 18, 2014, 6:49pm UTC](https://discourse.devontechnologies.com/t/not-operator-not-working/18121 "2014-12-18T18:49:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![mikes](https://discourse.devontechnologies.com/user_avatar/discourse.devontechnologies.com/mikes/32/6593_2.png) [@mikes](https://discourse.devontechnologies.com/u/mikes)\
**Post date:** [December 18, 2014, 6:49pm UTC](https://discourse.devontechnologies.com/t/not-operator-not-working/18121/1 "2014-12-18T18:49:04Z")

</div>

I have a an example query for the agent of the form:

((Oracle NEAR Database) NEAR (Mavericks OR “OS X” OR “10.9”)) AND !Dallas AND !“Oracle Arena”

the problem is that I get a ton of results that primarily about “Oracle Arena” and “Dallas” (specifically the Dallas Mavericks).

What is wrong with my query?

---

<div class="post-metadata">

**Author:** ![onClick](https://discourse.devontechnologies.com/user_avatar/discourse.devontechnologies.com/onclick/32/458_2.png) [@onClick](https://discourse.devontechnologies.com/u/onClick)\
**Post date:** [December 18, 2014, 8:55pm UTC](https://discourse.devontechnologies.com/t/not-operator-not-working/18121/2 "2014-12-18T20:55:28Z")

</div>

> [@mikes](#):
>
> ((Oracle NEAR Database) NEAR ((Mavericks OR “OS X”) OR “10.9”)) AND !Dallas AND !“Oracle Arena”

((Oracle NEAR Database) NEAR ((Mavericks OR “OS X”) OR “10.9”)) AND (!Dallas AND !“Oracle Arena”)

Without having access to my system to try, I’d guess that you need one more set of parenthesis (as above).

---

<div class="post-metadata">

**Author:** ![cgrunenberg](https://discourse.devontechnologies.com/user_avatar/discourse.devontechnologies.com/cgrunenberg/32/7172_2.png) [@cgrunenberg](https://discourse.devontechnologies.com/u/cgrunenberg)\
**Post date:** [December 19, 2014, 12:38pm UTC](https://discourse.devontechnologies.com/t/not-operator-not-working/18121/3 "2014-12-19T12:38:56Z")

</div>

Is the Express search enabled or disabled? And which “Search in” options are enabled, e.g. text, title, URL etc?

---

<div class="post-metadata">

**Author:** ![mikes](https://discourse.devontechnologies.com/user_avatar/discourse.devontechnologies.com/mikes/32/6593_2.png) [@mikes](https://discourse.devontechnologies.com/u/mikes)\
**Post date:** [December 19, 2014, 3:17pm UTC](https://discourse.devontechnologies.com/t/not-operator-not-working/18121/4 "2014-12-19T15:17:09Z")

</div>

Express search disabled.

“Search in” checked:

- Title
- Text
- URL
- Description

“Files” checked:

- HTML…
- Atom, RSS…
- Plain text documents
- Rich Text documents
- Microsoft Word Documents

---

<div class="post-metadata">

**Author:** ![cgrunenberg](https://discourse.devontechnologies.com/user_avatar/discourse.devontechnologies.com/cgrunenberg/32/7172_2.png) [@cgrunenberg](https://discourse.devontechnologies.com/u/cgrunenberg)\
**Post date:** [December 19, 2014, 3:22pm UTC](https://discourse.devontechnologies.com/t/not-operator-not-working/18121/5 "2014-12-19T15:22:58Z")

</div>

Which plugin or search set and which version of DEVONagent do you use? I just checked this using your search term and the results didn’t contain Dallas or arena.

---

<div class="post-metadata">

**Author:** ![system](https://devontech-discourse.s3.dualstack.us-east-1.amazonaws.com/uploads/original/2X/4/4e6ff70c96be2eb307a274d890bba8d71ba671b3.png) [@system](https://discourse.devontechnologies.com/u/system)\
**Post date:** [January 21, 2022, 11:23am UTC](https://discourse.devontechnologies.com/t/not-operator-not-working/18121/6 "2022-01-21T11:23:02Z")

</div>