QBSorts

Properties Summarized

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 Summarized

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 Detailed

parent

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

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

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

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

---