Page History

Divcache

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)
QBColumns

Table Cell (td)
columns Get columns from query

Table Row (tr)

Table Cell (td)
QBJoins

Table Cell (td)joins

styleindex	display:none

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.

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

idclass

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Property SummaryGet all the columns of the datasource that can be used for this query (select or where clause)Get the joins clause of this table based clause. Table Row (tr)

Table Cell (td)
QBLogicalCondition

Table Cell (td)on

Table Cell (td)parent

Get the on clause for the join.

Table Row (tr)

Table Cell (td)
QBTableClause

Get 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

Colgroup Tag

Col

width	80px

Col

Table Head (thead) Table Row (tr)style

servoy sSummary

Table Row (tr)

Table Cell (td)
QBColumn

Table Cell (td)getColumn(name)

12%

30%

58%

height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Row (tr)

Table Cell (td)
QBColumn

Table Cell (td)getColumn(columnTableAlias, name)

3

Methods Summary

Get a column from the table.

Get a column from the table with given alias

. 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	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

.

Returns the datasource for this.

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

Returns the table alias for this.

propertyservoy sDetail2100%height:30px2Property Detailscolumnsname

columns

des

sIndent

Get all the columns of the datasource that can be used for this query (select or where clause)

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

joins

name

joins

des

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)idtd

ret

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

QBJoins Table Row (tr)

SmartClient,WebClient,NGClient

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	on

Table Row (tr)

id	name

Table Cell (td)
on

Table Row (tr)

id	des

Table Cell (td) Div

class	sIndent

sIdent

javascript

lastDetailRow

on

name

on

des

sIndent

Get the on clause for the join.

Table Row (tr)id

ret

Table Cell (td)

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBLogicalCondition Table Row (tr)

id	sam

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

SmartClient,WebClient,NGClient

sam

Sample

Div

class	sIndent

Code Block

language	javascript

/** @type {QBSelect<db:/example_data/person>} */
var query = databaseManager.createSelect('db:/example_data/person')
/** @type {QBJoin<db:/example_data/person>} */
var join1 = query.joins.add('db:/example_data/person')
join1.on.add(query.columns.parent_person_id.eq(join1.columns.person_id))
/** @type {QBJoin<db:/example_data/person>} */
var join2 = query.joins.add('db:/example_data/person')
join2.on.add(join1.columns.parent_person_id.eq(join2.columns.person_id))

query.where.add(join2.columns.name.eq('john'))
foundset.loadRecords(query)

sIdent

javascript

lastDetailRow

parent

name

parent

des

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

sIndent

clients

classid

Supported Clients

sIndent

QBTableClause Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td)

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

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)

sIdent

javascript

lastDetailRow

root

name

root

des

sIndent

Get query builder parent.

Table Row (tr)idtd

ret

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

QBSelect Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td)

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	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

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

sIdent

javascript

lastDetailRow

functionservoy sDetail2100%height:30px2Methods DetailsgetColumnname

getColumn(name)

des

sIndent

Get a column from the table.

Table Row (tr)id

prs

Table Cell (td)class

Parameters

Div

sIndent

{String}

name

-

the name of column to get

Table Row (tr)idtd

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBColumn Table Row (tr)

id	sam

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBColumn

Span

style	font-weight: bold;

getColumn

Span

SmartClient,WebClient,NGClient

sam

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

sIdent

javascript

lastDetailRow

getColumn

name

getColumn(columnTableAlias, name)

tr

id Table Cell (td) Divclass

des

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

Divclass

sIndent{String} columnTableAlias - the alias for the table
{String} name - the name of column to getret

tr

Returns

id

sIndent

clients

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)

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getDataSource

name

getDataSource()

des

sIndent

Returns the datasource for this.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getJoinType

name

getJoinType()

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getTableAlias

name

getTableAlias()

des

sIndent

Returns the table alias for this.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

Child pages

Versions Compared

Old Version 13

New Version 14

Key

columns

joins

columns

joins

on

on

parent

parent

root

root

getColumn

getColumn(name)

getColumn

getColumn(columnTableAlias, name)

getDataSource()

getJoinType()

getTableAlias()