Skip to content

Feature Support

✅ Supported

🔶 Partially Supported

🔴 (Currently) Not Supported

Query Options

$select

✅ Select specific properties
✅ Select all structural properties with the star operator
✅ Select properties of related entities in the Expand Options ✅ Select navigation links
✅ Request all actions or functions available on every returned entity

$expand

✅ Request the value of related documents to be set inline
✅ Request the references to the related documents to be set inline with /$ref
✅ Expand Options

$compute

✅ Computed Properties

$filter

🔶 Filter Expressions (see Sections Logical Operators, Arithmetic Operators, Grouping and Functions) for a detailed overview of supported $filter features

$orderby

✅ Request ascending and descending ordering
✅ using $orderby in the Expand Options
🔴 Request ordering by the count of related entities or items within a collection-valued property

$top

✅ Request to limit the maximum number of items returned

$skip

✅ Request to skip the first n items of the query result

$count

✅ Request the total count of items in a collection to be returned along with the result
✅ Request the count of related entities within the Expand Options

✅ Search Terms
✅ Search Phrases
✅ NOT-Operator
✅ AND-Operator
✅ OR-Operator
🔶 Grouping with Parentheses

Types

✅ Edm.Binary
✅Edm.Boolean
🔴 Edm.Byte
✅ Edm.Date
✅ Edm.DateTimeOffset
✅ Edm.Decimal
🔴 Edm.Double
✅ Edm.Duration
✅ Edm.Guid
🔴 Edm.Int16
✅ Edm.Int32
🔴 Edm.Int64
🔴 Edm.SByte
🔴 Edm.Single
🔴 Edm.Stream
✅ Edm.String
✅ Edm.TimeOfDay
✅ Edm.Geography
✅ Edm.GeographyPoint
✅ Edm.GeographyLineString
✅ Edm.GeographyPolygon
✅ Edm.GeographyMultiPoint
✅ Edm.GeographyMultiLineString
✅ Edm.GeographyMultiPolygon
✅ Edm.GeographyCollection
✅ Edm.Geometry
✅ Edm.GeometryPoint
✅ Edm.GeometryLineString
✅ Edm.GeometryPolygon
✅ Edm.GeometryMultiPoint
✅ Edm.GeometryMultiLineString
✅ Edm.GeometryMultiPolygon
✅ Edm.GeometryCollection

Logical Operators

Comparison

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

Logical Expressions

✅ 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 parentheses

✅ Grouping with parenthesis

Functions

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)