| Get query builder parent table clause, this may be a query or a join clause. |
|
| Get query builder parent. |
|
|
| Add a join with join type IQueryBuilderJoin#LEFT_OUTER_JOIN and no alias for the joining table. |
|
| Add a join with no alias for the joining table. |
|
| Add a join clause from the parent query builder part to the specified data source. |
|
| Add a join based on relation or add a manual join. |
|
|
Get query builder parent table clause, this may be a query or a join clause. |
|
|
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) |
|
|
|
|
Get query builder parent. |
|
|
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) |
|
|
|
|
|
Add a join with join type IQueryBuilderJoin#LEFT_OUTER_JOIN and no alias for the joining table. |
|
|
Supported Clients | SmartClient,WebClient,NGClient |
|
|
Sample var query = datasources.db.example_data.orders.createSelect();
/** @type {QBJoin<db:/example_data/order_details>} */
var join = query.joins.add('db:/example_data/order_details', JSRelation.INNER_JOIN, 'odetail')
join.on.add(join.columns.orderid.eq(query.columns.orderid))
// to add a join based on a relation, use the relation name
var join2 = query.joins.add('orders_to_customers', 'cust')
query.where.add(join2.columns.customerid.eq(999))
foundset.loadRecords(query) |
|
|
|
|
add(dataSource, joinType) |
|
Add a join with no alias for the joining table. |
|
|
Parameters | join type, one of JSRelation.LEFT_OUTER_JOIN, JSRelation.INNER_JOIN, JSRelation.RIGHT_OUTER_JOIN, JSRelation.FULL_JOIN |
|
|
|
|
Supported Clients | SmartClient,WebClient,NGClient |
|
|
Sample var query = datasources.db.example_data.orders.createSelect();
/** @type {QBJoin<db:/example_data/order_details>} */
var join = query.joins.add('db:/example_data/order_details', JSRelation.INNER_JOIN, 'odetail')
join.on.add(join.columns.orderid.eq(query.columns.orderid))
// to add a join based on a relation, use the relation name
var join2 = query.joins.add('orders_to_customers', 'cust')
query.where.add(join2.columns.customerid.eq(999))
foundset.loadRecords(query) |
|
|
|
|
add(dataSource, joinType, alias) |
|
Add a join clause from the parent query builder part to the specified data source. |
|
|
Parameters | join type, one of IQueryBuilderJoin#LEFT_OUTER_JOIN, IQueryBuilderJoin#INNER_JOIN, IQueryBuilderJoin#RIGHT_OUTER_JOIN, IQueryBuilderJoin#FULL_JOIN |
|
| the alias for joining table |
|
|
|
|
Supported Clients | SmartClient,WebClient,NGClient |
|
|
Sample var query = datasources.db.example_data.orders.createSelect();
/** @type {QBJoin<db:/example_data/order_details>} */
var join = query.joins.add('db:/example_data/order_details', JSRelation.INNER_JOIN, 'odetail')
join.on.add(join.columns.orderid.eq(query.columns.orderid))
// to add a join based on a relation, use the relation name
var join2 = query.joins.add('orders_to_customers', 'cust')
query.where.add(join2.columns.customerid.eq(999))
foundset.loadRecords(query) |
|
|
|
|
add(dataSourceOrRelation, alias) |
|
Add a join based on relation or add a manual join.
When dataSourceOrRelation is a relation name, a join will be added based on the relation.
When dataSourceOrRelation is a data source, an empty join will be added with join type IQueryBuilderJoin#LEFT_OUTER_JOIN. |
|
|
Parameters | the alias for joining table |
|
|
|
|
Supported Clients | SmartClient,WebClient,NGClient |
|
|
Sample var query = datasources.db.example_data.orders.createSelect();
/** @type {QBJoin<db:/example_data/order_details>} */
var join = query.joins.add('db:/example_data/order_details', JSRelation.INNER_JOIN, 'odetail')
join.on.add(join.columns.orderid.eq(query.columns.orderid))
// to add a join based on a relation, use the relation name
var join2 = query.joins.add('orders_to_customers', 'cust')
query.where.add(join2.columns.customerid.eq(999))
foundset.loadRecords(query) |
|
|
|
|
Supported Clients | SmartClient,WebClient,NGClient |
|
|
|
|
|