QBSort

Overview

The QBSort class provides a wrapper for defining SQL sort conditions within the QBSelect framework. It allows for flexible and precise specification of sorting rules, integrating seamlessly with parent and root query references. Main functions include configuring ascending (asc) and descending (desc) sort orders, supporting diverse query components.

For additional details on query construction and execution, refer to the QBSelect documentation.

Properties Summarized

TypeNameSummary

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

Get query builder parent.

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)

Last updated