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.
QBLogicalCondition on
Get the on clause for the join.
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
 

on

Get the on clause for the join.

Returns

Sample

/** @type {QBSelect<db:/example_data/person>} */
var query = databaseManager.createSelect('db:/example_data/person')
/** @type {QBJoin<db:/example_data/person>} */
var join1 = query.joins.add('db:/example_data/person')
join1.on.add(query.columns.parent_person_id.eq(join1.columns.person_id))
/** @type {QBJoin<db:/example_data/person>} */
var join2 = query.joins.add('db:/example_data/person')
join2.on.add(join1.columns.parent_person_id.eq(join2.columns.person_id))

query.where.add(join2.columns.name.eq('john'))
foundset.loadRecords(query)
 

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