Attribute

DefaultQueryOptions (dqo)

Purpose

Specifies a semicolon-separated list of parameters that are used as default filter values (Where clauses) for SQL queries. When querying a table, the default query parameters specified by this option (or filters specified in SQL Where clauses) are appended as query parameters to REST API calls to the endpoint for the queried table.

Valid Values

string

where:

string

is a set of parameters and default filter values that you want to apply to SQL queries.

Examples

If you specified the following value for this option:

invoice>=2000;region=americas
Or specified the following equivalent value in a SQL statement: 
SELECT customer_name FROM accounts WHERE invoice >= 2000 AND region = americas

The following REST API call would be called to the driver to return results: 

https://www.example.com/times/query?invoice>=2000&region=americas

Notes

  • A Where clause used in a SQL query overrides the DefaultQueryOptions passed in a connection URL.

Default Value

No default value