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

Table Cell (td)parent

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

id Table Row (tr)

Table Cell (td)
QBSorts

Table Cell (td)add(columnSortAsc)

12%

30%

58%

height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Row (tr)

Table Cell (td)
QBSorts

Table Cell (td)add(functionSortAsc)

3

Methods Summary

Ad an ascending sorting on a column to the query sort.

Table Row (tr)

Table Cell (td)
QBSorts

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

Table Cell (td)
QBSorts

Table Cell (td)addPk()

Ad a sorting on a column to the query sort.

Add the tables' primary pk columns in alphabetical order to the query sort.

Table Row (tr)

Table Cell (td)
QBSorts

Table Cell (td)clear()

Clear the sorting clause for the query.

HTML Table

propertyclass Colgroup Tag Colcolspanservoy sDetail2width100%

Col

Table Head (thead) Table Row (tr)style

height:30px

; Table Head (th)colspan

2

Property Details

Table Body (tbody)idid

parent

Table Row (tr)

name

td

parent

Table Row (tr)id

des

Table Cell (td) Divclass

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

QBSelect 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

classtd

Supported Clients

sIndent

QBSelect Table Row (tr)

id	sam

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

Table Row (tr)

id	name

Table Cell (td)
add

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBSorts

Span

style	font-weight: bold;

add

Span
(columnSortAsc)

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

add(columnSortAsc)

des

sIndent

Ad an ascending sorting on a column to the query sort.

Table Row (tr)id

prs

Table Cell (td)

Parameters

Divclass

sIndent{QBColumn} columnSortAsc - column to sort by Table Row (tr)idtdret

Returns

div

sIndent

clients

class Table Row (tr)

id	sam

td

Supported Clients

sIndent

QBSorts

Table Row (tr)

id	name

Table Cell (td)
add

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBSorts

Span

style	font-weight: bold;

add

Span
(functionSortAsc)

Table Row (tr)

id	des

Table Cell (td) Div

class	sIndent

SmartClient,WebClient,NGClient

sam

Sample

Div

class	sIndent

Code Block

language	javascript

query.sort.add(query.columns.orderid)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	add-QBFunction

sIdent

javascript

lastDetailRow

add

name

add(functionSortAsc)

des

sIndent

Ad an ascending sorting on a column to the query sort.

Table Row (tr)id

prs

Table Cell (td)

Parameters

Divclass

sIndent{QBFunction} functionSortAsc - function to add Table Row (tr)idtdret

Returns

div

sIndent

clients

classQBSorts Table Row (tr)

id	sam

td

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

Div

class	sIndent

Code Block

language	javascript

query.sort.add(query.columns.orderid)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	add-QBSort

Table Row (tr)

id	name

Table Cell (td)
add

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBSorts

Span

style	font-weight: bold;

add

Span
(sort)

Table Row (tr)

id	des

Table Cell (td) Div

class	sIndent

sIdent

javascript

lastDetailRow

add

name

add(sort)

des

sIndent

Ad a sorting on a column to the query sort.

Table Row (tr)id

prs

Table Cell (td)

Parameters

Divclass

sIndent{QBSort} sort - the sort to add Table Row (tr)idtdret

Returns

div

sIndent

clients

classQBSorts Table Row (tr)id

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Table Cell (td) Table Body (tbody)

id	addPk

Table Row (tr)

id	name

Table Cell (td)
addPk

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBSorts

Span

style	font-weight: bold;

addPk

Span
()

Table Row (tr)

id	des

Table Cell (td) Div

class	sIndent

Sample

Div

class	sIndent

Code Block

language	javascript

query.sort.add(query.columns.orderid.desc)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

sIdent

javascript

lastDetailRow

addPk

name

addPk()

des

sIndent

Add the tables' primary pk columns in alphabetical order to the query sort.

Table Row (tr)id

ret

Table Cell (td)

Returns

div

sIndent

clients

classQBSorts Table Row (tr)

id	sam

td

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

Div

class	sIndent

Code Block

language	javascript

query.sort.addPk()

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	clear

Table Row (tr)

id	name

Table Cell (td)
clear

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBSorts

Span

style	font-weight: bold;

clear

Span
()

Table Row (tr)

id	des

Table Cell (td) Div

class	sIndent

sIdent

javascript

lastDetailRow

clear

name

clear()

des

sIndent

Clear the sorting clause for the query.

Table Row (tr)idtd

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBSorts Table Row (tr)

id	sam

SmartClient,WebClient,NGClient

sam

Sample

Div

class	sIndent

Code Block

language	javascript

query.sort.clear()

Table Row (tr)

class	lastDetailRow

Table Cell (td)

sIdent

javascript

lastDetailRow

Child pages

Versions Compared

Old Version 13

New Version 14

Key

parent

root

root

add

add(columnSortAsc)

add

add(functionSortAsc)

add

add(sort)

addPk

addPk()

clear

clear()