DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR.



Property Summary
QBColumns
columns
Get columns from query
QBJoins
joins
Get the joins clause of this table based clause.
QBTableClause
parent
Get query builder parent table clause, this may be a query or a join clause.
QBSelect
root
Get query builder parent.



Method Summary
QBColumn
getColumn(name)
Get a column from the table.
QBColumn
getColumn(columnTableAlias, name)
Get a column from the table with given alias.



Property Details

columns

Get columns from query

Returns

QBColumns

Sample

foundset.getQuery().columns
 

joins

Get the joins clause of this table based clause.
Joins added to this clause will be based on this table clauses table.

Returns

QBJoins

Sample

foundset.getQuery().joins
 

parent

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

Returns

QBTableClause

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

getColumn

QBColumn
getColumn
(name)
Get a column from the table.

Parameters

{String} name - the name of column to get

Returns

QBColumn

Sample

foundset.getQuery().getColumn('orderid')
 

getColumn

QBColumn
getColumn
(columnTableAlias, name)
Get a column from the table with given alias.
The alias may be of the main table or any level deep joined table.

Parameters

{String} columnTableAlias - the alias for the table
{String} name - the name of column to get

Returns

QBColumn

Sample

foundset.getQuery().getColumn('orderid', 'opk')