Creates a delete query for one or more tables of an API connection.
The name of the table to delete the record from.
The field values to set on this table when the query is executed.
The filter condition for the table.
The information on tables used on this query.
Set additional filter for last table added to the query.
The filter condition to set on the table
Returns the current query instance (fluent interface).
Asynchronously executes the delete query and, when fulfilled, returns the number of affected (deleted) rows.
The query execution timeout (milliseconds).
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).
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).
Set the value to be assigned for a field when the query is executed, this applies for the last table added to the query.
The name of the field, use square brackets to specify an array item.
The value to set for that field.
Returns the current query instance (fluent interface).
Asynchronously executes the update query on the connection and, when fulfilled, returns the updated row(s) or the number of rows affected.
An open connection to the akera.io application server.
The update query to execute.
If set to true the complete record will be returned if updated (field values might be updated by triggers).
The query execution timeout (milliseconds).
A 'delete' query is used to delete record 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. When executed, all records that match are being deleted - first from child(s) then from parent table.
1.1.0