May 02, 2024 13:26 Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients SampleSupported 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
var query = foundset.getQuery();
query.result.add(query.columns.name, "name");
query.where.add(query.columns.orderdate.isNull)
joins
foundset.getQuery().joins
parent
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
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)
String
name
the name of column to get
foundset.getQuery().getColumn('orderid')
getColumn(columnTableAlias, name)
String
columnTableAlias
the alias for the table
String
name
the name of column to get
foundset.getQuery().getColumn('orderid', 'opk')
getDataSource()
getTableAlias()