Returns Supported Clients Sample Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample
Apr 13, 2024 12:45Supported Clients
SmartClient
WebClient
NGClient
Property Summary
QBSelect
parent
Get query builder parent table clause, this may be a query or a join clause.
QBSelect
root
Get query builder parent.
Methods Summary
QBGroupBy
add(column)
Add column name to group-by clause.
QBGroupBy
add(function)
Add column name to group-by clause.
QBGroupBy
addPk()
Add the tables' primary pk columns in alphabetical order to the group by clause.
QBGroupBy
clear()
Clear the to group-by clause.
Property Details
parent
Get query builder parent table clause, this may be a query or a join clause.
SmartClient,WebClient,NGClient
var query = datasources.db.example_data.person.createSelect();
query.where.add(query.joins.person_to_parent.joins.person_to_parent.columns.name.eq('john'))
foundset.loadRecords(query)
root
Get query builder parent.
SmartClient,WebClient,NGClient
var subquery = datasources.db.example_data.order_details.createSelect();
var query = datasources.db.example_data.orders.createSelect();
query.where.add(query
.or
.add(query.columns.order_id.not.isin([1, 2, 3]))
.add(query.exists(
subquery.where.add(subquery.columns.orderid.eq(query.columns.order_id)).root
))
)
foundset.loadRecords(query)
Methods Details
add(column)
Add column name to group-by clause.
Same as query.groupBy().add(join.getColumn("value"))QBColumn
column
the column to add to the query condition
SmartClient,WebClient,NGClient
var query = datasources.db.example_data.orders.createSelect();
query.groupBy.add(query.columns.orderid) // 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)
add(function)
Add column name to group-by clause.
Same as query.groupBy().add(join.getColumn("value"))QBColumn
function
the function to add to the query
SmartClient,WebClient,NGClient
var query = datasources.db.example_data.orders.createSelect();
query.groupBy.add(query.columns.orderid) // 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)
addPk()
Add the tables' primary pk columns in alphabetical order to the group by clause.
SmartClient,WebClient,NGClient
var query = datasources.db.example_data.orders.createSelect();
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)
clear()
Clear the to group-by clause.
SmartClient,WebClient,NGClient
var q = foundset.getQuery()
q.where.add(q.columns.x.eq(100))
query.groupBy.clear.root.clearHaving()
foundset.loadRecords(q);
Overview
Content Tools
Activity