skip to main content
Querying with OData Version 4 : Formulating queries with OData Version 4 : Query options and optimizing response times
  

Try Now

Query options and optimizing response times

You can refine query results using system query options, which begin with the $ character. Add system query options to the URL to control the amount and order of data in the response. Custom query parameters lists additional parameters specific to Hybrid Data Pipeline . In addition, topics in this section describe settings to optimize response times when paging through result sets or when using the $count system parameter.
The following table lists the OData query string options that Hybrid Data Pipeline supports. For detailed information about the system query options, refer to the OData specification.
Table 148. Supported system query options
Option
Description
Support in Hybrid Data Pipeline
$count
Returns the number of records in a collection, or if the collection has a filter, the number of records that match the filter.
Note: $count replaces the $inlinecount parameter for OData v4 and higher.
Supports all standard functionality.
$expand
In addition to retrieving a record or collection, retrieve related records.
At present, supports expanding one level deep.
$filter
An expression or function that must evaluate to true for records that will be included in the response.
Supports all functionality except the following scalar functions: fractionalseconds, geodistance, geointersects, geolength, isof, maxdatetime, mindatetime, totaloffsetminutes, totalseconds.
$orderby
Determines the values used to order a collection of records.
Supports all standard functionality.
$top
Identifies a subset of records to return from a collection. To form this subset, select only the first N items of the set, where N is a positive integer. See Paging through results for more information.
Supports all standard functionality.
$skip
Identifies a subset of records to return from a collection. Define the subset by seeking N entries into the Collection and selecting only the remaining entries (starting with Entry N+1), where N is a positive integer.
Supports all standard functionality.
$search
Searches for the specified expression in columns that are enabled for search in the schema map. Do not use $search and $filter in the same request. See Searching text-based columns for more information.
Note: $search replaces the DataDirect proprietary ddsearch parameter for OData v4 and higher.
Supports all standard functionality.
$value
Gets the raw value of a property.
Supports all standard functionality.
Note: In case of stored functions, only $filter and $orderby system query options are supported. Currently, Hybrid Data Pipeline supports OData version 4 functions for Oracle data source only.
* Improving performance when using Count
* Paging through results
* Custom query parameters