Inhaltsverzeichnis
2.2 OData Filter
The $filter parameter enables complex queries.
Comparison Operators
| Operator | Meaning | Example |
|---|---|---|
eq | Equal | Country eq 'DE' |
ne | Not equal | Status ne 'closed' |
gt | Greater than | Price gt 100 |
ge | Greater or equal | Age ge 18 |
lt | Less than | Stock lt 10 |
le | Less or equal | Rating le 5 |
Logical Operators
| Operator | Example |
|---|---|
and | Country eq 'DE' and Active eq true |
or | Status eq 'new' or Status eq 'pending' |
not | not endswith(Name,'Ltd') |
String Functions
$filter=contains(Name,'mueller') $filter=startswith(Email,'info@') $filter=endswith(Name,'Inc')
Example
/odata/demo/Customers?$filter=Country eq 'Germany' and contains(Name,'GmbH')&$orderby=Name
Zuletzt geändert: on 2026/01/29 at 11:30 PM
