servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientservoy sSummary12%30%58%height: 30px;3Property SummaryGet query builder parent table clause, this may be a query or a join clause.Get query builder parent.servoy sSummary12%30%58%height: 30px;3Methods SummaryAdd a join clause from the parent query builder part to a derived table based on another query.Add a join clause from the parent query builder part to a derived table based on another query.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.propertyservoy sDetail2100%height:30px2Property Detailsparentname
parent
dessIndent
Get query builder parent table clause, this may be a query or a join clause.
Add a join clause from the parent query builder part to a derived table based on another query.
prs
Parameters
sIndentsubqueryBuilder ;joinType ;ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddname
add(subqueryBuilder, joinType, alias)
dessIndent
Add a join clause from the parent query builder part to a derived table based on another query.
prs
Parameters
sIndentsubqueryBuilder ;joinType ;alias ;ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddname
add(dataSource)
dessIndent
Add a join with join type IQueryBuilderJoin#LEFT_OUTER_JOIN and no alias for the joining table.
prs
Parameters
sIndentdataSourcedata sourceret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddname
add(dataSource, joinType)
dessIndent
Add a join with no alias for the joining table.
prs
Parameters
sIndentdataSourcedata sourcejoinTypejoin type, one of JSRelationQBJoin.LEFT_OUTER_JOIN, JSRelationQBJoin.INNER_JOIN, JSRelationQBJoin.RIGHT_OUTER_JOIN, JSRelationQBJoin.FULL_JOINret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddname
add(dataSource, joinType, alias)
dessIndent
Add a join clause from the parent query builder part to the specified data source.
prs
Parameters
sIndentdataSourcedata sourcejoinTypejoin type, one of IQueryBuilderJoin#LEFT_OUTER_JOIN, IQueryBuilderJoin#INNER_JOIN, IQueryBuilderJoin#RIGHT_OUTER_JOIN, IQueryBuilderJoin#FULL_JOINaliasthe alias for joining tableret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddname
add(dataSourceOrRelation, alias)
dessIndent
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.
prs
Parameters
sIndentdataSourceOrRelationdata sourcealiasthe alias for joining tableret