Supported Options
The following OData system query functions are supported:
-
$filter
-
String
-
contains
-
endswith
-
startswith
$filter applied on String properties is case-insensitive. "Permission Group 1" is considered the same as "permission grouP 1". The same is
true for all comparison operators (eq, ne, gt, ge, lt, le) and functions (contains,
endswith, startswith).
-
-
Comparison
-
eq
-
ne
-
gt
-
ge
-
lt
-
le
-
and
-
or
-
not
-
-
Lamda Operators
-
any
-
all
-
Examples of filtering on navigation collection:
/Plants('PlantKey')/Interfaces?$filter=Properties/any(x: x/ScopedbyList/Name ne 'ApprovalReason')/Plants('PlantKey')/Interfaces?$filter=Properties/all(x: x/ScopedbyList/Name ne 'ApprovalReason')
-
-
$expand
-
$select
-
$orderby
-
$top
-
$skip
-
$count
-
$value
Unsupported Options
The following OData system query functions are not supported:
-
$filter on dynamic properties
-
$orderby on dynamic properties