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

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Current »



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

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

Sample

foundset.getQuery().joins
 

parent

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

Returns

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

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

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

Sample

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



  • No labels