Connector name | OData v4 InMemory | OData v4 MongoDB | OData v4 MS-SQL | OData v4 MySQL | OData v4 PostgreSQL |
---|---|---|---|---|---|
Module name | odata-v4-inmemory | odata-v4-mongodb | odata-v4-mssql | odata-v4-mysql | odata-v4-pg |
$filter | |||||
contains | yes | yes | yes | yes | yes |
startswith | yes | yes | yes | yes | yes |
endswith | yes | yes | yes | yes | yes |
length | yes | no | yes | yes | yes |
indexof | yes | no | no | no | no |
substring | yes | no | yes | yes | yes |
tolower | yes | no | yes | yes | yes |
toupper | yes | no | yes | yes | yes |
trim | yes | no | yes | yes | yes |
concat | yes | no | yes | yes | yes |
year | yes | no | yes | yes | yes |
month | yes | no | yes | yes | yes |
day | yes | no | yes | yes | yes |
hour | yes | no | yes | yes | yes |
minute | yes | no | yes | yes | yes |
second | yes | no | yes | yes | yes |
fractionalseconds | no | no | no | no | no |
totalseconds | no | no | no | no | no |
date | no | no | no | no | no |
time | no | no | no | no | no |
totaloffsetminutes | no | no | no | no | no |
mindatetime | yes | no | no | no | no |
maxdatetime | yes | no | no | no | no |
now | yes | no | yes | yes | yes |
round | yes | no | yes | yes | yes |
floor | yes | no | yes | yes | yes |
ceiling | yes | no | yes | yes | yes |
geo.distance | pro | pro | pro | pro | pro |
geo.length | pro | pro | pro | pro | pro |
geo.intersects | pro | pro | pro | pro | pro |
and | yes | yes | yes | yes | yes |
or | yes | yes | yes | yes | yes |
eq | yes | yes | yes | yes | yes |
ne | yes | yes | yes | yes | yes |
lt | yes | yes | yes | yes | yes |
le | yes | yes | yes | yes | yes |
gt | yes | yes | yes | yes | yes |
ge | yes | yes | yes | yes | yes |
has | no | no | no | no | no |
add | yes | no | yes | yes | yes |
sub | yes | no | yes | yes | yes |
mul | yes | no | yes | yes | yes |
div | yes | no | yes | yes | yes |
mod | yes | no | yes | yes | yes |
- (negate) | yes | no | yes | yes | yes |
not | yes | yes | yes | yes | yes |
isof | yes | no | no | no | no |
cast | no | no | no | no | no |
any | yes | no | no | no | no |
all | yes | no | no | no | no |
$count (inline count) | yes | yes | yes | yes | yes |
$orderby | no | yes | yes | yes | yes |
$search | no | no | no | no | no |
$select | no | yes | yes | yes | yes |
$skip | no | yes | yes | yes | yes |
$top | no | yes | yes | yes | yes |
$expand | no | yes | yes | yes | yes |
$levels | no | no | no | no | no |
$skiptoken | no | no | no | no | no |
Features marked as “pro” mean that they will be available in the final Commercial Edition. We do not have an exact release date for this, please get back often for updates or contact us in case you are interested.