---
title: And, Or, Not
slug: and-or-not
createdAt: 2023-03-19T15:55:54.000Z
---
A query consists of one or multiple **Query Terms**, which are connected using the logical operators `and` or `or`.
Query Terms are **grouped together in a right-associative manner**. What that beauty of a sentence means is that if you write this:
:::BlockQuote
**name** **contains** **"inc"** **or** **name** **contains** **"ltd"** **and** **industry** **=** **"Banking"**
:::
It will be interpreted like this:
:::BlockQuote
**name** **contains** **"inc"** **or**** ( ****name** **contains** **"ltd"** **and** **industry** **=** **"Banking"** **)**
:::
This will match Accounts satisfying **either** of the following conditions:
- `name` contains `"inc"`
- `name` contains `"ltd"` **and** `industry` is `"Banking"`
***
::::hint{type="info"}
*In general, if you have something like this:*
:::BlockQuote
**QT1** **and** **QT2** **or** **QT3** **and** **QT4** **or** ...
:::
*It will be interpreted like this:*
:::BlockQuote
**QT1** **and** **(** **QT2** **or** **(** **QT3** **and** **(** **QT4** **or** **(** ... **) ) ) )**
:::
*It doesn't matter if you use ****and**** or ****or***.
::::
***
Explicit parenthesis **`( )`** can be used to change this however you wish.
:::BlockQuote
**( ****name** **contains** **"inc"** **or** **name** **contains** **"ltd"** **) ****and** **industry** **=** **"Banking"**
:::
This will match Accounts satisfying **both** of the following conditions:
- `name` contains `"inc"` **or** `"ltd"`
- `industry` is `"Banking"`****
You can also wrap one or more Query Terms in `not ( )`, which **negates **the terms:
:::BlockQuote
**not** **(** **name** **contains** **"inc"** **or** **name** **contains** **"ltd"** **)** **and** **industry** **=** **"Banking"**
:::
This will match Accounts satisfying **both** of the following conditions:
- `name` contains **neither** `"inc"` nor `"ltd"`
- `industry` is `"Banking"`
:::BlockQuote
******name** **contains** **"inc"** **or** **not (** **name** **contains** **"ltd"** **and** **industry** **=** **"Banking"** **)**
:::
This will match Accounts satisfying **either** of the following conditions:
- `name` contains `"inc"`
- either `name` doesn't contain `"ltd"` or `industry` isn't `"Banking"`, or both
***
:::hint{type="warning"}
*There are some nuances about how negations and searching fields on linked records interact with each other, which might not be immediately apparent. Check out the section on *[linked fields](docId\:kzBTLLYb4xfJ8DF290vXI)*.*
:::