DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING. THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR.Enter additional information related to this 'class' inside the {
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.eq(0))
foundset.loadRecords(query)
Table Row (tr)
class
lastDetailRow
Table Cell (td)
Table Body (tbody)
id
having
Table Row (tr)
id
name
Table Cell (td)
having
Table Row (tr)
id
des
Table Cell (td)
Div
class
sIndent
Get the having-part of the query, used to add conditions. The conditions added here are AND-ed.
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.eq(0))
foundset.loadRecords(query)
Table Row (tr)
class
lastDetailRow
Table Cell (td)
Table Body (tbody)
id
joins
Table Row (tr)
id
name
Table Cell (td)
joins
Table Row (tr)
id
des
Table Cell (td)
Div
class
sIndent
Get the joins clause of this table based clause. Joins added to this clause will be based on this table clauses table.