Servoy 6.1.x
Child pages
  • QBTableClause
Skip to end of metadata
Go to start of metadata


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.
<p>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.
<p>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')
  • No labels