====== 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 =====

<code>
$filter=contains(Name,'mueller')
$filter=startswith(Email,'info@')
$filter=endswith(Name,'Inc')
</code>

===== Example =====

<code>
/odata/demo/Customers?$filter=Country eq 'Germany' and contains(Name,'GmbH')&$orderby=Name
</code>