Adapter specific OData Service operations

The 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.

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

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