OData Logical Operators
The following logical operators are valid in an OData Filter.
| Operator | Example |
|---|---|
| Or | $filter=Price le 3.5 or Price gt 200 |
| And | $filter=Price le 200 and Price gt 3.5 |
| Equal | $filter=Address/City eq ‘Redmond’ |
| NotEqual | $filter=Address/City ne ‘London’ |
| GreaterThan | $filter=Price gt 20 |
| GreaterThanOrEqual | $filter=Price ge 10 |
| LessThan | $filter=Price lt 20 |
| LessThanOrEqual | $filter=Price le 100 |
| Not | $filter=not Price eq 20 |