QBGroupBy

Property Summary

Type	Name	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

Type	Name	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..

Properties Details

parent

Get query builder parent table clause, this may be a query or a join clause.

Returns QBSelect

Sample

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.

Returns QBSelect

Sample

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"))

Parameters QBColumn column the column to add to the query condition

Returns QBGroupBy

Sample

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"))

Parameters QBColumn function the function to add to the query

Returns QBGroupBy

Sample

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.

Returns QBGroupBy

Sample

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.

Returns QBGroupBy

Sample

var q = foundset.getQuery()
q.where.add(q.columns.x.eq(100))
query.groupBy.clear.root.clearHaving()
foundset.loadRecords(q);