QBTableClause

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')