JayData.org

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
method call expressions:
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
logical expressions:
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
lamba expressions:
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.