This repository has been archived by the owner on Dec 29, 2020. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
Supported Query Syntax
Trevor Pilley edited this page Oct 5, 2020
·
9 revisions
The following parts of the OData specification are supported (or not) by the library.
| Operator | OData Version | Library Status |
|---|---|---|
$count=true |
4.0 | implemented in Net.Http.OData 5.0.0 |
$count=false |
4.0 | implemented in Net.Http.OData 5.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
wildcard $expand =*
|
4.0 | implemented in Net.Http.OData 5.0.0 |
properties $expand=Orders
|
4.0 | implemented in Net.Http.OData 5.0.0 |
nested properties $select=Orders/Product
|
4.0 | implemented in Net.Http.OData 5.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
| eq | 4.0 | implemented in Net.Http.OData 5.0.0 |
| ne | 4.0 | implemented in Net.Http.OData 5.0.0 |
| gt | 4.0 | implemented in Net.Http.OData 5.0.0 |
| ge | 4.0 | implemented in Net.Http.OData 5.0.0 |
| lt | 4.0 | implemented in Net.Http.OData 5.0.0 |
| le | 4.0 | implemented in Net.Http.OData 5.0.0 |
| and | 4.0 | implemented in Net.Http.OData 5.0.0 |
| or | 4.0 | implemented in Net.Http.OData 5.0.0 |
| not | 4.0 | implemented in Net.Http.OData 5.0.0 |
| has | 4.0 | implemented in Net.Http.OData 5.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
| add | 4.0 | implemented in Net.Http.OData 5.0.0 |
| sub | 4.0 | implemented in Net.Http.OData 5.0.0 |
| mul | 4.0 | implemented in Net.Http.OData 5.0.0 |
| div | 4.0 | implemented in Net.Http.OData 5.0.0 |
| mod | 4.0 | implemented in Net.Http.OData 5.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
() Precedence Grouping |
4.0 | implemented in Net.Http.OData 5.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
| concat | 4.0 | implemented in Net.Http.OData 5.0.0 |
| contains | 4.0 | implemented in Net.Http.OData 5.0.0 |
| endswith | 4.0 | implemented in Net.Http.OData 5.0.0 |
| indexof | 4.0 | implemented in Net.Http.OData 5.0.0 |
| length | 4.0 | implemented in Net.Http.OData 5.0.0 |
| startswith | 4.0 | implemented in Net.Http.OData 5.0.0 |
| substring | 4.0 | implemented in Net.Http.OData 5.0.0 |
| tolower | 4.0 | implemented in Net.Http.OData 5.0.0 |
| toupper | 4.0 | implemented in Net.Http.OData 5.0.0 |
| trim | 4.0 | implemented in Net.Http.OData 5.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
| date | 4.0 | implemented in Net.Http.OData 5.0.0 |
| day | 4.0 | implemented in Net.Http.OData 5.0.0 |
| fractionalseconds | 4.0 | implemented in Net.Http.OData 5.0.0 |
| hour | 4.0 | implemented in Net.Http.OData 5.0.0 |
| maxdatetime | 4.0 | implemented in Net.Http.OData 5.0.0 |
| mindatetime | 4.0 | implemented in Net.Http.OData 5.0.0 |
| minute | 4.0 | implemented in Net.Http.OData 5.0.0 |
| month | 4.0 | implemented in Net.Http.OData 5.0.0 |
| now | 4.0 | implemented in Net.Http.OData 5.0.0 |
| second | 4.0 | implemented in Net.Http.OData 5.0.0 |
| time | 4.0 | implemented in Net.Http.OData 5.1.0 |
| totaloffsetminutes | 4.0 | implemented in Net.Http.OData 5.0.0 |
| totalseconds | 4.0 | implemented in Net.Http.OData 5.1.0 |
| year | 4.0 | implemented in Net.Http.OData 5.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
| ceiling | 4.0 | implemented in Net.Http.OData 5.0.0 |
| floor | 4.0 | implemented in Net.Http.OData 5.0.0 |
| round | 4.0 | implemented in Net.Http.OData 5.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
| cast | 4.0 | implemented in Net.Http.OData 5.0.0 |
| isof | 4.0 | implemented in Net.Http.OData 5.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
| geo.distance | 4.0 | not implemented |
| geo.intersects | 4.0 | not implemented |
| geo.length | 4.0 | not implemented |
| Operator | OData Version | Library Status |
|---|---|---|
| any | 4.0 | implementing in Net.Http.OData 6.0.0 |
| all | 4.0 | implementing in Net.Http.OData 6.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
$format=atom |
4.0 | not implemented |
$format=json |
4.0 | implemented in Net.Http.OData 5.0.0 |
$format=xml |
4.0 | not implemented |
$format=application/json |
4.0 | implemented in Net.Http.OData 5.0.0 |
$format=application/... |
4.0 | not implemented |
| Operator | OData Version | Library Status |
|---|---|---|
asc $orderby=Name asc
|
4.0 | implemented in Net.Http.OData 5.0.0 |
desc $orderby=Name desc
|
4.0 | implemented in Net.Http.OData 5.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
wildcard $select=*
|
4.0 | implemented in Net.Http.OData 5.0.0 |
properties $select=Name, DateOfBirth
|
4.0 | implemented in Net.Http.OData 5.0.0 |
nested properties $select=Address/Postcode
|
4.0 | implemented in Net.Http.OData 5.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
$skip=10 |
4.0 | implemented in Net.Http.OData 5.0.0 |
| Operator | OData Version | Library Status |
|---|---|---|
$top=5 |
4.0 | implemented in Net.Http.OData 5.0.0 |