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

Table Cell (td)id

parent

Table Row (tr)

des

Table Cell (td) Divclass

sIndent

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

Table Row (tr)idtd

retReturnsdivsIndentclientsclassid
Supported Clients
sIndentQBSelect Table Row (tr)SmartClient,WebClient,NGClientsam 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 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
Ad an ascending sorting on a column to the query sort.
 Table Row (tr)
id prs
 Table Cell (td)
Parameters
 Div
class sIndent
{QBColumn} columnSortAsc - column to sort by
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
QBSorts
 Table Row (tr)
id sam
 Table Cell (td)
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
 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
Ad an ascending sorting on a column to the query sort.
 Table Row (tr)
id prs
 Table Cell (td)
Parameters
 Div
class sIndent
{QBFunction} functionSortAsc - function to add
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
QBSorts
 Table Row (tr)
id sam
 Table Cell (td)
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
Ad a sorting on a column to the query sort.
 Table Row (tr)
id prs
 Table Cell (td)
Parameters
 Div
class sIndent
{QBSort} sort - the sort to add
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
QBSorts
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
query.sort.add(query.columns.orderid.desc)
 Table Row (tr)
class lastDetailRow
 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
Add the tables' primary pk columns in alphabetical order to the query sort.
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
QBSorts
 Table Row (tr)
id sam
 Table Cell (td)
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
Clear the sorting clause for the query.
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
QBSorts
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
query.sort.clear()
 Table Row (tr)class lastDetailRow
 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 Tableid function
class servoy sDetail
sIdentjavascriptlastDetailRowrootnamerootdessIndentGet query builder parent.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRow
functionservoy sDetail2100%height:30px2Methods Detailsaddname
add(columnSortAsc)dessIndentAd an ascending sorting on a column to the query sort.prsParameters
sIndentcolumnSortAsccolumn to sort byretReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowaddnameadd(functionSortAsc)dessIndentAd an ascending sorting on a column to the query sort.prsParameters
sIndentfunctionSortAscfunction to addretReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowaddnameadd(sort)dessIndentAd a sorting on a column to the query sort.prsParameters
sIndentsortthe sort to addretReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowaddPknameaddPk()dessIndentAdd the tables' primary pk columns in alphabetical order to the query sort.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowclearnameclear()dessIndentClear the sorting clause for the query.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRow

Child pages

Versions Compared

Old Version 13

New Version Current

Key

parent

add

add

add

addPk

clear

root

root

add(columnSortAsc)

add(functionSortAsc)

add(sort)

addPk()

clear()