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