Page History
...
Divcache | ||
---|---|---|
| DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
...
id | description |
---|
...
padding | 0px |
---|---|
width | 80px |
...
Table Row (tr) | |||||
---|---|---|---|---|---|
| |||||
|
...
Table Cell (td) |
---|
QBTableClause |
...
Table Cell (td) |
---|
QBSelect |
...
| |||||||||||||
...
...
padding | 0px |
---|---|
width | 80px |
...
...
...
Table Head (th) | ||
---|---|---|
| ||
Method Summary |
...
Table Cell (td) |
---|
QBJoin |
...
Table Cell (td) |
---|
QBJoin |
...
...
...
...
Table Cell (td) |
---|
QBJoin |
...
...
Table Cell (td) |
---|
QBJoin |
...
...
id | property |
---|---|
class | servoy sDetail |
...
padding | 0px |
---|---|
width | 100% |
Table Row (tr) | |||||
---|---|---|---|---|---|
| |||||
|
...
id | parent |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | root |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | function |
---|---|
class | servoy sDetail |
...
padding | 0px |
---|---|
width | 100% |
Table Row (tr) | |||||
---|---|---|---|---|---|
| |||||
|
...
id | add-String |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | add-String_Number |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | add-String_Number_String |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
...
id | prs |
---|
...
class | sIndent |
---|
...
parentGet query builder parent table clause, this may be a query or a join clause. Returns Supported Clients Sample rootGet query builder parent. Returns Supported Clients Sample add(subqueryBuilder, joinType)Add a join clause from the parent query builder part to a derived table based on another query. Parameters Returns Supported Clients Sample add(subqueryBuilder, joinType, alias)Add a join clause from the parent query builder part to a derived table based on another query. Parameters Returns Supported Clients Sample add(dataSource)Add a join with join type IQueryBuilderJoin#LEFT_OUTER_JOIN and no alias for the joining table. Parameters Returns Supported Clients Sample add(dataSource, joinType)Add a join with no alias for the joining table. Parameters Returns Supported Clients Sample add(dataSource, joinType, alias)Add a join clause from the parent query builder part to the specified data source. Parameters |
...
...
...
...
Returns |
...
...
Supported Clients |
...
...
class | lastDetailRow |
---|
...
id | add-String_String |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
...
id | sig |
---|
...
Span | ||
---|---|---|
| ||
QBJoin |
Span | ||
---|---|---|
| ||
add |
...
Sample |
...
class | sIndent |
---|
...
Code Block | ||
---|---|---|
| ||
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
/** @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 |
...
...
...
...
...
...
...
Returns |
...
...
class | lastDetailRow |
---|
...
Supported Clients |
...
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
Sample getJoins()Returns Supported Clients Sample removeUnused(keepInnerjoins)Remove the joins that are not used anywhere in the query. Parameters Returns Supported Clients Sample |
Overview
Content Tools
Activity