QBTableClause

Property Summary

Type	Name	Summary
QBColumns	columns	Get all the columns of the datasource that can be used for this query (select or where clause).
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..

Methods Summary

Type	Name	Summary
QBColumn	getColumn(name)	Get a column from the table..
QBColumn	getColumn(columnTableAlias, name)	Get a column from the table with given alias..
String	getDataSource()	Returns the datasource for this..
String	getTableAlias()	Returns the table alias for this..

Properties Details

columns

Get all the columns of the datasource that can be used for this query (select or where clause)

Returns QBColumns

Sample

var query = foundset.getQuery();
query.result.add(query.columns.name, "name");
query.where.add(query.columns.orderdate.isNull)

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

var query = datasources.db.example_data.person.createSelect();
	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

var subquery = datasources.db.example_data.order_details.createSelect();

	var query = datasources.db.example_data.orders.createSelect();
	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)

Methods Details

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

getDataSource()

Returns the datasource for this.

Returns String the dataSource

Sample

getTableAlias()

Returns the table alias for this.

Returns String the tableAlias

Sample