Analytics SAQL Developer Guide
jNote: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.
Logical Operators
Use logical operators to perform AND, OR, and NOT operations.
Logical operators can return true, false, or null.
| Operator | Name | Description |
|---|---|---|
| && (and) | Logical AND | See table. |
| || (or) | Logical OR | See table. |
| ! (not) | Logical NOT | See table. |
The following tables show how nulls are handled in logical operations.
| x | y | x && y | x || y |
|---|---|---|---|
| True | True | True | True |
| True | False | False | True |
| True | Null | Null | True |
| False | True | False | True |
| False | False | False | False |
| False | Null | False | Null |
| Null | True | Null | True |
| Null | False | False | Null |
| Null | Null | Null | Null |
| x | !x |
|---|---|
| True | False |
| False | True |
| Null | Null |