Creates a select query for one or more tables of an API connection.
The name of the table to select the records from.
The filter condition for the table.
The information on tables used on this query.
Asynchronously executes the select query and, when fulfilled, returns all the rows that satisfy the filter condition.
The query execution timeout (milliseconds).
Build the query statement that can be executed on an open IConnection.
Asynchronously executes the select query and, when fulfilled, returns the number of rows that satisfy the filter condition.
The query execution timeout (milliseconds).
Specify the fields to retrieve for the last table addted to the query. Field information can be just the name or a structure with name, alias and extent where only the name is mandatory.
To select all fields the wildcard character ('*') can be used.
If the the extent information is set, either in the field structure or inside the name using the square bracket notation (MonthQuota[2]), then only that entry from the array field is retrieved otherwise all values are returned as an array.
At least one field information is required.
Extra entries with field information.
Set additional filter for the last table added to the query.
The filter condition to set on the table
Returns the current query instance (fluent interface).
Joins another table to the query.
The name of the joined table.
The parent table to join on.
Returns the current query instance (fluent interface).
Set the maximum number of records selected when pagination is used.
The select limit, must be greater or equal to one.
Returns the current query instance (fluent interface).
Set the start offset when pagination is used.
The start offset, must be greater or equal to one.
Returns the current query instance (fluent interface).
Adds an additional field mapping for the last table joined to the query.
The name of the field in the parent table.
Returns the current query instance (fluent interface).
Open a query for sequential data access (fetch one row at a time).
The query execution timeout (milliseconds).
The query object that can be used to navigate through the records.
Specify the sort order for records selection. Each sort field information can be either a string - the field name or an object with a single property and a logical value (true for descending). When only the field name is specified the sort order is ascending.
At least one sort field information is required.
Extra entries with sort field information.
Asynchronously executes a select query and, when fulfilled, returns all the rows that satisfy the filter condition.
An open connection on which the query is to be executed.
The select query to execute.
The query execution timeout (milliseconds).
A 'select' query is used to retrieve records from one or more tables. The query does support multiple tables but those need to be related (joined). Optional filter can be set for each table used on the query.
1.1.0