Supported Clients
SmartClient
WebClient
NGClient

Property 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
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.

Property Details

columns

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

Returns

QBColumns

Supported Clients

SmartClient,WebClient,NGClient

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

Supported Clients

SmartClient,WebClient,NGClient

Sample

foundset.getQuery().joins

parent

Get query builder parent table clause, this may be a query or a join clause.

Returns

QBTableClause

Supported Clients

SmartClient,WebClient,NGClient

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

Supported Clients

SmartClient,WebClient,NGClient

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

Supported Clients

SmartClient,WebClient,NGClient

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

Supported Clients

SmartClient,WebClient,NGClient

Sample

foundset.getQuery().getColumn('orderid', 'opk')

getDataSource()

Returns the datasource for this.

Returns

String the dataSource

Supported Clients

SmartClient,WebClient,NGClient

Sample

getTableAlias()

Returns the table alias for this.

Returns

String the tableAlias

Supported Clients

SmartClient,WebClient,NGClient

Sample