Page History

DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR.
Enter additional information related to this 'class' inside the {div} macro with 'id=description'

Divcache

styleindex	display:none

Div

id	description

HTML Table

id

class

servoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

Table Row (tr)

Table Cell (td)
QBTableClause

Table Cell (td)parent

true
refresh	100d
showRefresh	true
id	doc
title	Refresh page
showDate	true
retry	Enable

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Property SummaryGet query builder parent table clause, this may be a query or a join clause. Table Row (tr)

Table Cell (td)
QBSelect

Table Cell (td)root

Get query builder parent.

HTML Table

idclassservoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead) Table Row (tr)style

servoy sSummary

12%

30%

58%

height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Row (tr)

Table Cell (td)
QBJoin

Table Cell (td)add(dataSource)
Table Row (tr)

Table Cell (td)
QBJoin

Table Cell (td)add(dataSource, joinType)

3

Methods Summary

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.

Table Row (tr)

Table Cell (td)
QBJoin

Table Cell (td)add(dataSource, joinType, alias)
Table Row (tr)

Table Cell (td)
QBJoin

Table Cell (td)add(dataSourceOrRelation, alias)

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.

HTML Table

id	property
class	servoy sDetail

Colgroup Tag

Col

colspan	2
width	100%

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Details

Table Body (tbody)

id	parent

Table Row (tr)

id	name

Table Cell (td)
parent

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get query builder parent table clause, this may be a query or a join clause.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBTableClause

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @type {QBSelect<db:/example_data/person>} */
	var query = databaseManager.createSelect('db:/example_data/person')
	query.where.add(query.joins.person_to_parent.joins.person_to_parent.columns.name.eq('john'))
	foundset.loadRecords(query)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	root

Table Row (tr)

id	name

Table Cell (td)
root

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get query builder parent.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBSelect

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @type {QBSelect<db:/example_data/order_details>} */
	var subquery = databaseManager.createSelect('db:/example_data/order_details')

 /** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	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)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

HTML Table

id	function
class	servoy sDetail

Colgroup Tag

Col

colspan	2
width	100%

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Details

Table Body (tbody)

id	add-String

Table Row (tr)

id	name

Table Cell (td)
add

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBJoin

Span

style	font-weight: bold;

add

Span
(dataSource)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Add a join with join type IQueryBuilderJoin#LEFT_OUTER_JOIN and no alias for the joining table.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} dataSource - data source

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBJoin

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	add-String_Number

Table Row (tr)

id	name

Table Cell (td)
add

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBJoin

Span

style	font-weight: bold;

add

Span
(dataSource, joinType)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Add a join with no alias for the joining table.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} dataSource - data source
{Number} joinType - join type, one of JSRelation.LEFT_OUTER_JOIN, JSRelation.INNER_JOIN, JSRelation.RIGHT_OUTER_JOIN, JSRelation.FULL_JOIN

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBJoin

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	add-String_Number_String

Table Row (tr)

id	name

Table Cell (td)
add

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBJoin

Span

style	font-weight: bold;

add

Span
(dataSource, joinType, alias)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Add a join clause from the parent query builder part to the specified data source.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} dataSource - data source
{Number} joinType -

Remove the joins that are not used anywhere in the query.

propertyservoy sDetail2100%height:30px2Property Detailsparentname

parent

des

sIndent

Get query builder parent table clause, this may be a query or a join clause.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

root

name

root

des

sIndent

Get query builder parent.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

functionservoy sDetail2100%height:30px2Methods Detailsaddname

add(subqueryBuilder, joinType)

des

sIndent

Add a join clause from the parent query builder part to a derived table based on another query.

prs

Parameters

sIndent

subqueryBuilder

;

joinType

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

add

name

add(subqueryBuilder, joinType, alias)

des

sIndent

Add a join clause from the parent query builder part to a derived table based on another query.

prs

Parameters

sIndent

subqueryBuilder

;

joinType

;

alias

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

add

name

add(dataSource)

des

sIndent

Add a join with join type IQueryBuilderJoin#LEFT_OUTER_JOIN and no alias for the joining table.

prs

Parameters

sIndent

dataSource

data source

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

add

name

add(dataSource, joinType)

des

sIndent

Add a join with no alias for the joining table.

prs

Parameters

sIndent

dataSource

data source

joinType

join type, one of QBJoin.LEFT_OUTER_JOIN, QBJoin.INNER_JOIN, QBJoin.RIGHT_OUTER_JOIN, QBJoin.FULL_JOIN

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

add

name

add(dataSource, joinType, alias)

des

sIndent

Add a join clause from the parent query builder part to the specified data source.

prs

Parameters

sIndent

dataSource

data source

joinType

join type, one of IQueryBuilderJoin#LEFT_OUTER_JOIN, IQueryBuilderJoin#INNER_JOIN, IQueryBuilderJoin#RIGHT_OUTER_JOIN, IQueryBuilderJoin#FULL_JOIN

{String}

alias

- Table Row (tr)id

the alias for joining table

ret

Table Cell (td)

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

QBJoin Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	add-String_String

Table Row (tr)

id	name

Table Cell (td)
add

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBJoin

Span

style	font-weight: bold;

add

Span

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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)

id

sIdent

javascript

lastDetailRow

add

name

add(dataSourceOrRelation, alias)

Table Row (tr)class

des

Table Cell (td) Div

sIndent

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.

id


When dataSourceOrRelation is a data source, an empty join will be added with join type IQueryBuilderJoin#LEFT_OUTER_JOIN.

Table Row (tr)

prs

Table Cell (td)class

Parameters

Div

sIndent

{String}

dataSourceOrRelation

-

data source

{String}

alias

- Table Row (tr)id

the alias for joining table

td

ret

Returns

div

sIndent

clients

class Table Row (tr)

class	lastDetailRow

Table Cell (td)

Supported Clients

sIndent

QBJoin

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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)

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getJoins

name

getJoins()

des

sIndent

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

removeUnused

name

removeUnused(keepInnerjoins)

des

sIndent

Remove the joins that are not used anywhere in the query.

prs

Parameters

sIndent

keepInnerjoins

when true inner joins are not removed, inner joins may impact the query result, even when not used

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

Child pages

Versions Compared

Old Version 11

New Version Current

Key

parent

root

add

add

add

parent

root

add(subqueryBuilder, joinType)

add(subqueryBuilder, joinType, alias)

add(dataSource)

add(dataSource, joinType)

add(dataSource, joinType, alias)

add

add(dataSourceOrRelation, alias)

getJoins()

removeUnused(keepInnerjoins)