QBSorts

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
QBSorts	add(columnSortAsc)	Ad an ascending sorting on a column to the query sort..
QBSorts	add(functionSortAsc)	Ad an ascending sorting on a column to the query sort..
QBSorts	add(sort)	Ad a sorting on a column to the query sort..
QBSorts	addPk()	Add the tables' primary pk columns in alphabetical order to the query sort..
QBSorts	clear()	Clear the sorting clause for the query..

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(columnSortAsc)

Ad an ascending sorting on a column to the query sort.

Parameters QBColumn columnSortAsc column to sort by

Returns QBSorts

Sample

query.sort.add(query.columns.orderid)

add(functionSortAsc)

Ad an ascending sorting on a column to the query sort.

Parameters QBColumn functionSortAsc function to add

Returns QBSorts

Sample

query.sort.add(query.columns.orderid)

add(sort)

Ad a sorting on a column to the query sort.

Parameters QBSort sort the sort to add

Returns QBSorts

Sample

query.sort.add(query.columns.orderid.desc)

addPk()

Add the tables' primary pk columns in alphabetical order to the query sort.

Returns QBSorts

Sample

query.sort.addPk()

clear()

Clear the sorting clause for the query.

Returns QBSorts

Sample

query.sort.clear()