Page History

...

HTML Table

id
class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBColumns

Table Cell (td)
#columns columns Get columns from query

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBJoins

Table Cell (td)
#joins joins Get the joins clause of this table based clause.

Table Row (tr)

Table Cell (td)
QBTableClause

Table Cell (td)
#parent parent Get query builder parent table clause, this may be a query or a join clause.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBSelect

Table Cell (td)
#root root Get query builder parent.

HTML Table

id
class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

tbody

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

tbody

Table Row (tr)

Table Cell (td)
QBColumn

Table Cell (td)
#getColumn getColumn(name) Get a column from the table.

Table Row (tr)

Table Cell (td)
QBColumn

Table Cell (td)
#getColumn getColumn(columnTableAlias, name) Get a column from the table with given alias.

HTML Table

id	property
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Property Details

Table Body (tbody)

id	columns

Table Row (tr)

id	name

Table Cell (td)
columns

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get columns from query

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBColumns

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

foundset.getQuery().columns

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	joins

Table Row (tr)

id	name

Table Cell (td)
joins

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get the joins clause of this table based clause.
Joins added to this clause will be based on this table clauses table.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBJoins

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

foundset.getQuery().joins

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

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

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Method Details

Table Body (tbody)

id	getColumn-String

Table Row (tr)

id	name

Table Cell (td)
getColumn

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBColumn

Span

style	font-weight: bold;

getColumn

Span
(name)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get a column from the table.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} name

...

- the name of column to get

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBColumn

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

foundset.getQuery().getColumn('orderid')

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getColumn-String_String

Table Row (tr)

id	name

Table Cell (td)
getColumn

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBColumn

Span

style	font-weight: bold;

getColumn

Span
(columnTableAlias, name)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get a column from the table with given alias.
The alias may be of the main table or any level deep joined table.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} columnTableAlias

...

- the alias for the table
{String} name

...

- the name of column to get

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBColumn

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

foundset.getQuery().getColumn('orderid', 'opk')

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 9

New Version 10

Key

columns

joins

parent

root

getColumn

getColumn