Adapter specific OData Service operations
Adapter for JDBC converts OData System queries to equivalent SQL query
that correspond to the OData operations. The OData operations such as retrieve,
insert, delete and update correspond to select, insert, delete,
and update SQL queries for each external entity type.
Adapter for JDBC also supports filter expressions in OData requests to
filter and return only those results that match the expression specified. You can add the
$filter system query option at the end of the OData request.
Note:
$filter system query option is applicable only for
retrieve operation.
Adapter for JDBC
supports the following operators:
| Operator | Description | Example |
|---|---|---|
eq
|
Equal |
$filter=City eq 'Redmond'
|
ne
|
Not Equal |
$filter=City ne 'London'
|
gt
|
Greater than |
$filter=Price gt 20
|
lt
|
Less than |
$filter=Price lt 20
|
ge
|
Greater than or equal |
$filter=Price ge 10
|
le
|
Less than or equal |
$filter=Price le 100
|
and
|
Logical and |
$filter=Price le 200 and Price gt 3.5
|
or
|
Logical or |
$filter=Price le 3.5 or Price gt 200
|
Adapter for JDBC
supports the following functions:
| Function | Description | Example |
|---|---|---|
endswith
|
Returns the string that ends with the specified suffix |
$filter=endswith(FText,'RT')
|
startswith
|
Returns the string that starts with the specified prefix |
$filter=startswith(FText, 'S')
|
substringof
|
Returns the string that contains the specified substring |
$filter=substringof(FText, 'urn') eq true
|
substring
|
Returns the string that contains the specified substring at the specified index |
$filter=substring(FText, 5) eq 'RED'
|
tolower
|
Convert to lower case |
$filter=tolower(FText) eq 'code red'
|
toupper
|
Convert to upper case |
$filter=toupper(FText) eq '2ND ROW'
|
trim
|
Removes leading and trailing spaces |
$filter=trim(FText) eq 'CODE RED'
|
concat
|
Concatenates the specified properties |
$filter=concat(concat(FText, ', '), FCode) eq '2nd row,
CODE RED'
|
round
|
Rounds a numeric field |
$filter=round(FDecimal) eq 1
|
floor
|
Gets the largest integer value that is not greater than property value |
$filter=floor(FDecimal) eq 0
|
ceiling
|
Gets the smallest integer value that is greater than property value |
$filter=ceiling(FDecimal) eq 0
|
Note: The functions such as
ceiling and
round are applicable only for Oracle database.