QBAggregates

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
QBColumn	avg(Object)	Create avg(value) expression.
QBColumn	count()	Create count(*) expression.
QBColumn	count(Object)	Create count(value) expression.
QBColumn	max(Object)	Create max(value) expression.
QBColumn	min(Object)	Create min(value) expression.
QBColumn	sum(Object)	Create sum(value) expression.

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

avg(Object)

Create avg(value) expression

Parameters Object

Returns QBColumn

Sample

var query = datasources.db.example_data.orders.createSelect();
	query.result.add(query.aggregates.avg(query.columns.amount)).add(query.columns.countryCode)
	query.groupBy.add(query.columns.countryCode)
 var ds = databaseManager.getDataSetByQuery(query, 100);

count()

Create count(*) expression

Returns QBColumn

Sample

var query = datasources.db.example_data.orders.createSelect();
	query.result.add(query.aggregates.count().add(query.columns.countryCode)
	query.groupBy.add(query.columns.countryCode)
 var ds = databaseManager.getDataSetByQuery(query, 100);

count(Object)

Create count(value) expression

Parameters Object

Returns QBColumn

Sample

var query = datasources.db.example_data.orders.createSelect();
	query.result.add(query.aggregates.count(query.columns.amount)).add(query.columns.countryCode)
	query.groupBy.add(query.columns.countryCode)
 var ds = databaseManager.getDataSetByQuery(query, 100);

max(Object)

Create max(value) expression

Parameters Object

Returns QBColumn

Sample

var query = datasources.db.example_data.orders.createSelect();
	query.result.add(query.aggregates.max(query.columns.amount)).add(query.columns.countryCode)
	query.groupBy.add(query.columns.countryCode)
 var ds = databaseManager.getDataSetByQuery(query, 100);

min(Object)

Create min(value) expression

Parameters Object

Returns QBColumn

Sample

var query = datasources.db.example_data.orders.createSelect();
	query.result.add(query.aggregates.min(query.columns.amount)).add(query.columns.countryCode)
	query.groupBy.add(query.columns.countryCode)
 var ds = databaseManager.getDataSetByQuery(query, 100);

sum(Object)

Create sum(value) expression

Parameters Object

Returns QBColumn

Sample

var query = datasources.db.example_data.orders.createSelect();
	query.result.add(query.aggregates.sum(query.columns.amount)).add(query.columns.countryCode)
	query.groupBy.add(query.columns.countryCode)
 var ds = databaseManager.getDataSetByQuery(query, 100);