Child pages
  • QBSorts
Skip to end of metadata
Go to start of metadata

Refresh page Mar 16, 2024 22:03

Supported Clients
SmartClient WebClient NGClient

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.

Methods 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

Supported Clients

SmartClient,WebClient,NGClient

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

Supported Clients

SmartClient,WebClient,NGClient

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

Supported Clients

SmartClient,WebClient,NGClient

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

Supported Clients

SmartClient,WebClient,NGClient

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

Supported Clients

SmartClient,WebClient,NGClient

Sample

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

addPk()

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

Returns

Supported Clients

SmartClient,WebClient,NGClient

Sample

query.sort.addPk()

clear()

Clear the sorting clause for the query.

Returns

Supported Clients

SmartClient,WebClient,NGClient

Sample

query.sort.clear()

  • No labels