QBSorts

Property Summary

Methods Summary

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

Last updated