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 |
...
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
HTML Table | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
Colgroup Tag | Column | | ||||||||||||
|
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 |
---|
{Number} joinType –
...
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) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
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 {String} Table Row (tr) | | id | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Table Cell (td) | id | |||||||||||
QBJoin | ||||||||||||
Table Row (tr) | ||||||||||||
Table Cell (td) | ||||||||||||
Table Cell (td) |
Span | ||
---|---|---|
| ||
QBJoin |
Span | ||
---|---|---|
| ||
add |
Sample
Div | |||||
---|---|---|---|---|---|
| |||||
|
class | lastDetailRow |
---|
id | add-String_String |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
id | sig |
---|
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
{String}
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