odatafy MongoDB documentation

Feature Support

✅ Supported

🔶 Partially Supported

🔴 (Currently) Not Supported

Query Options

$select

$expand

$compute

$filter

$orderby

$top

$skip

$count

$search

Types

Logical Operators

Comparison

✅ eq (Equals)
✅ ne (Not Equals)
✅ gt (Greater Than)
✅ lt (Less Than)

Logical Experssions

✅ and (Logical and)
✅ or (Logical or)
✅ not (Logical not)

Other

🔴 has (Has operator)
🔴 in (In operator)

Arithmetic Operators

Addition

✅ add (Numeric Types)
🔶 add (Date Types)

Subtraction

✅ sub (Numeric Types)
🔶 sub (Date Types)

Multiplication

✅ mul (Numeric Types)
🔴 mul (Date Types)

Division

✅ div (Numeric Types)
🔴 div (Date Types)
✅ divby (Numeric Types)
✅ mod (Numeric Types)

Negation

✅ - (Numeric Types)

✅ Grouping with parenthesis

String and Collection Functions

concat

✅ concat(String, String)
✅ concat(Collection, Collection)

contains

✅ contains(String, String)
✅ contains(Collection, Collection)

endswith

✅ endswith(String, String)
🔴 endswith(Collection, Collection)

indexof

🔴 indexof(String, String)
🔴 indexof(Collection, Collection)

length

✅ length(Edm.String)
✅ length(Collection)

startswith

✅ startswith(String, String)
🔴 startswith(Collection, Collection)

substring

🔴 substring(String, Number)
🔴 substring(String, Number, Number)
🔴 substring(Collection, Number)
🔴 substring(Collection, Number, Number)

Collection Functions

🔴 hassubset(Collection, Collection)
🔴 hassubsequence(Collection, Collection)

String Functions

✅ matchesPattern(String, String)
✅ tolower(String)
✅ toupper(String)
✅ trim(String)

Date and Time Functions

🔴 date(Datetime)
✅ year(Date)
✅ year(Datetime)
✅ month(Date)
✅ month(Datetime)
✅ day(Date)
✅ day(Datetime)
🔴 time(Date)
🔴 time(Datetime)
✅ hour(Date)
✅ hour(Datetime)
✅ minute(Datetime)
✅ second(Datetime)
✅ fractionalseconds(Datetime)
🔴 totaloffsetminutes(Datetime)
🔴 totalseconds(Datetime)
✅ maxdatetime()
✅ now()
✅ mindatetime()

Arithmetic Functions

✅ ceiling(Number)
✅ floor(Number)
✅ round(Number)

Type Functions

🔴 cast(Type)
🔶 cast(Expression, Type)
🔴 isof(Type)
🔴 isof(Expression, Type)

Geo Functions

geo.distance

🔴 geo.distance(GeographyPoint, GeographyPoint)
🔴 geo.distance(GeometryPoint, GeometryPoint)

geo.intersects

🔴 geo.intersects(GeographyPoint, GeographyPolygon)
🔴 geo.intersects(GeometryPoint, GeometryPolygon)

geo.length

🔴 geo.length(GeographyLineString)
🔴 geo.length(GeometryLineString)

Conditional Functions

🔴 case(Edm.Boolean:expression, ..., Edm.Boolean:expression)

Lambda Operators

🔴 any(Symbol:Edm.Boolean:expression)
🔴 all(Symbol:Edm.Boolean:expression)