QBSorts

Property Summary
QBSelect	parent Get query builder parent table clause, this may be a query or a join clause.
QBSelect	root Get query builder parent.

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

Property Details
parent
Get query builder parent table clause, this may be a query or a join clause.
Returns QBSelect
Sample /** @type {QBSelect<db:/example_data/person>} */ var query = databaseManager.createSelect('db:/example_data/person') 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 /** @type {QBSelect<db:/example_data/order_details>} / var subquery = databaseManager.createSelect('db:/example_data/order_details') /* @type {QBSelect<db:/example_data/orders>} */ var query = databaseManager.createSelect('db:/example_data/orders') 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)

Method Details
add
QBSorts 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
QBSorts add (functionSortAsc)
Ad an ascending sorting on a column to the query sort.
Parameters {QBFunction} functionSortAsc - function to add
Returns QBSorts
Sample query.sort.add(query.columns.orderid)

add
QBSorts 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
QBSorts addPk ()
Add the tables' primary pk columns in alphabetical order to the query sort.
Returns QBSorts
Sample query.sort.addPk()

clear
QBSorts clear ()
Clear the sorting clause for the query.
Returns QBSorts
Sample query.sort.clear()