Page History

...

style	display:none

...

id	description

...

padding	0px
width	80px

...

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

...

Table Cell (td)
QBSelect

...

Table Cell (td)
QBSelect

...

Cache

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

...

Get query builder parent.

...

padding	0px
width	80px

...

servoy sSummary

12%

30%

58%

height: 30px;

...

Table Head (th)

colspan	2

Method Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#abs(value) Create abs(column) expression

...

Table Cell (td)
QBFunction

...

3

Methods Summary

Create abs(column) expression

Create bit_length(column) expression

...

Table Cell (td)
QBFunction

...

Table Cell (td)
QBFunction

...

Cast using type name.

...

Create ceil(column) expression

...

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#coalesce(args) Create year(date) expression

...

Table Cell (td)
QBFunction

...

Table Cell (td)
QBFunction

...

Create year(date) expression

Create concat(args, arg2) expression

...

Create day(date) expression

...

Table Cell (td)
QBFunction

...

Table Cell (td)
QBFunction

...

Create divide(args, arg2) expression

...

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#floor(arg) Create floor(column) expression

...

Create floor(column) expression

Create hour(date) expression

...

Table Cell (td)
QBFunction

...

Create length(column) expression

...

Table Cell (td)
QBFunction

...

Table Cell (td)
QBFunction

...

Create locate(str1, str2) expression

Create locate(str1, str2, start) expression

...

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#locate(string1, string2, start) Create locate(str1, str2, start) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#lower(value) Create lower(column) expression

...

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)

...

class	lastDetailRow

...

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

Table Row (tr)

id	name

Table Cell (td)
abs

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

abs

Span
(value)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create abs(column) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} value

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mynum.abs.eq(query.functions.abs(myval))) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	bit_length-Object

Table Row (tr)

id	name

Table Cell (td)
bit_length

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

bit_length

Span
(value)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create bit_length(column) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} value

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.shipname.bit_length.eq(query.functions.bit_length('Sample'))) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	cast-Object_String

Table Row (tr)

id	name

Table Cell (td)
cast

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

cast

Span
(value, type)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Cast using type name.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} value – object to cast
{String} type – type see QUERY_COLUMN_TYPES

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	ceil-Object

Table Row (tr)

id	name

Table Cell (td)
ceil

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

ceil

Span
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create ceil(column) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg – number object

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.ceil.eq(query.functions.ceil(myvar)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	coalesce-ObjectArray

Table Row (tr)

id	name

Table Cell (td)
coalesce

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

coalesce

Span
(args)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create year(date) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object...} args – arguments to coalesce

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mycol.coalesce('defval').eq(query.functions.coalesce(myvar, 'defval')) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	concat-Object_Object

Table Row (tr)

id	name

Table Cell (td)
concat

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

concat

Span
(arg1, arg2)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create concat(args, arg2) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg1
{Object} arg2

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript


/** @type {QBSelect<db:/udm/contacts>} */
	var query = databaseManager.createSelect('db:/udm/contacts') //$NON-NLS-1$
	query.result.add(query.columns.name_first.concat(' ').concat(query.columns.name_last))
	var ds = databaseManager.getDataSetByQuery(query, -1)

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	day-Object

Table Row (tr)

id	name

Table Cell (td)
day

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

day

Span
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create day(date) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg – date object

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.day.eq(query.functions.day(mydatevar)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	divide-Object_Object

Table Row (tr)

id	name

Table Cell (td)
divide

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

divide

Span
(arg1, arg2)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create divide(args, arg2) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg1
{Object} arg2

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.divide(2).eq(query.functions.divide(myvar, 2)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	floor-Object

Table Row (tr)

id	name

Table Cell (td)
floor

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

floor

Span
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create floor(column) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg – number object

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.floor.eq(query.functions.floor(myvar)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	hour-Object

Table Row (tr)

id	name

Table Cell (td)
hour

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

hour

Span
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create hour(date) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg – date object

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.hour.eq(query.functions.hour(mydatevar)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	len-Object

Table Row (tr)

id	name

Table Cell (td)
len

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

len

Span
(value)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create length(column) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} value

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.shipname.len.eq(query.functions.len('Sample'))) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	locate-Object_Object

Table Row (tr)

id	name

Table Cell (td)
locate

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

locate

Span
(string1, string2)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create locate(str1, str2) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} string1 – string to locate
{Object} string2 – string to search in

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.shipname.locate('amp').eq(query.functions.locate('Sample', 'amp'))) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	locate-Object_Object_Number

Table Row (tr)

id	name

Table Cell (td)
locate

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

locate

Span
(string1, string2, start)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create locate(str1, str2, start) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} string1 – string to locate
{Object} string2 – string to search in
{Number} start – start pos

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.shipname.locate('amp', 1).eq(query.functions.locate('Sample', 'amp', 1))) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	lower-Object

Table Row (tr)

id	name

Table Cell (td)
lower

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

lower

Span
(value)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create lower(column) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} value

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.shipname.lower.eq(query.functions.lower('Sample'))) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	minus-Object_Object

Table Row (tr)

id	name

Table Cell (td)
minus

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

minus

Span
(arg1, arg2)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create minus(args, arg2) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg1
{Object} arg2

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.minus(2).eq(query.functions.minus(myvar, 2)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	minute-Object

Table Row (tr)

id	name

Table Cell (td)
minute

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

minute

Span
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create minute(date) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg – date object

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.minute.eq(query.functions.minute(mydatevar)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	mod-Object_Object

Table Row (tr)

id	name

Table Cell (td)
mod

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

mod

Span
(dividend, divisor)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create mod(dividend, divisor) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} dividend
{Object} divisor

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.mod(2).eq(query.functions.mod(myvar, 2)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	month-Object

Table Row (tr)

id	name

Table Cell (td)
month

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

month

Span
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create month(date) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg – date object

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.month.eq(query.functions.month(mydatevar)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	multiply-Object_Object

Table Row (tr)

id	name

Table Cell (td)
multiply

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

multiply

Span
(arg1, arg2)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create multiply(args, arg2) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg1
{Object} arg2

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.multiply(2).eq(query.functions.multiply(myvar, 2)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	nullif-Object

Table Row (tr)

id	name

Table Cell (td)
nullif

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

nullif

Span
(arg1)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create nullif(arg1, arg2) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg1

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.shipname.nullif('none').eq(query.functions.nullif('Sample', 'none'))) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	plus-Object_Object

Table Row (tr)

id	name

Table Cell (td)
plus

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

plus

Span
(arg1, arg2)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create plus(args, arg2) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg1
{Object} arg2

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.plus(2).eq(query.functions.plus(myvar, 2)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	round-Object

Table Row (tr)

id	name

Table Cell (td)
round

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

round

Span
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create round(column) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg – number object

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.round.eq(query.functions.round(myvar)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	second-Object

Table Row (tr)

id	name

Table Cell (td)
second

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

second

Span
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create second(date) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg – date object

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.second.eq(query.functions.second(mydatevar)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	sqrt-Object

Table Row (tr)

id	name

Table Cell (td)
sqrt

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

sqrt

Span
(value)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create sqrt(column) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} value

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mynum.sqrt.eq(query.functions.sqrt(myval))) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	substring-Object_Number

Table Row (tr)

id	name

Table Cell (td)
substring

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

substring

Span
(arg, pos)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create substring(column, pos) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg – column name
{Number} pos – position

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.shipname.substring(3).eq(query.functions.substring('Sample', 3))) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	substring-Object_Number_Number

Table Row (tr)

id	name

Table Cell (td)
substring

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

substring

Span
(arg, pos, len)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create substring(column, pos, len) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg – column name
{Number} pos – position
{Number} len – length

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.shipname.substring(3, 2).eq(query.functions.substring('Sample', 3, 2))) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	trim-Object

Table Row (tr)

id	name

Table Cell (td)
trim

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

trim

Span
(value)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create trim(column) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} value

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.shipname.trim.eq(query.functions.trim('Sample'))) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	upper-Object

Table Row (tr)

id	name

Table Cell (td)
upper

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

upper

Span
(value)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create upper(column) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} value

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.shipname.upper.eq(query.functions.upper('Sample'))) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	year-Object

Table Row (tr)

id	name

Table Cell (td)
year

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

year

Span
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create year(date) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg – date object

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunction

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') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.year.eq(query.functions.year(mydatevar)) 
foundset.loadRecords(query);

Table Row (tr)

class	lastDetailRow

td

Create lower(column) expression

Create minus(args, arg2) expression

Create minute(date) expression

Create mod(dividend, divisor) expression

Create month(date) expression

Create multiply(args, arg2) expression

...

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#minute(arg) Create minute(date) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#mod(dividend, divisor) Create mod(dividend, divisor) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#month(arg) Create month(date) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#multiply(arg1, arg2) Create multiply(args, arg2) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#nullif(arg1) Create nullif(arg1, arg2) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#plus(arg1, arg2) Create plus(args, arg2) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#round(arg) Create round(column) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#second(arg) Create second(date) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#sqrt(value) Create sqrt(column) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#substring(arg, pos) Create substring(column, pos) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#substring(arg, pos, len) Create substring(column, pos, len) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#trim(value) Create trim(column) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#upper(value) Create upper(column) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#year(arg) Create year(date) expression

...

id	property
class	servoy sDetail

...

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Property Details

...

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

QBSelect

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)

...

class	lastDetailRow

...

id	root

Create nullif(arg1, arg2) expression

Create plus(args, arg2) expression

Create round(column) expression

Create second(date) expression

Create sqrt(column) expression

Create substring(column, pos) expression

Create substring(column, pos, len) expression

Create trim(column) expression

Create trim([leading | trailing | both] [characters] from column)

Create upper(column) expression

Create year(date) expression

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 Detailsabsname

abs(value)

des

sIndent

Create abs(column) expression

prs

Parameters

sIndent

value

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

bit_length

name

bit_length(value)

des

sIndent

Create bit_length(column) expression

prs

Parameters

sIndent

value

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

cast

name

cast(value, type)

des

sIndent

Cast using type name.

prs

Parameters

sIndent

value

object to cast

type

type see QUERY_COLUMN_TYPES

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

ceil

name

ceil(arg)

des

sIndent

Create ceil(column) expression

prs

Parameters

sIndent

arg

number object

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

coalesce

name

coalesce(args)

des

sIndent

Create year(date) expression

prs

Parameters

sIndent

args

arguments to coalesce

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

concat

name

concat(arg1, arg2)

des

sIndent

Create concat(args, arg2) expression

prs

Parameters

sIndent

arg1

;

arg2

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

custom

name

custom(name, args)

des

sIndent

prs

Parameters

sIndent

name

custom function name

args

function arguments

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

day

name

day(arg)

des

sIndent

Create day(date) expression

prs

Parameters

sIndent

arg

date object

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

divide

name

divide(arg1, arg2)

des

sIndent

Create divide(args, arg2) expression

prs

Parameters

sIndent

arg1

;

arg2

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

floor

name

floor(arg)

des

sIndent

Create floor(column) expression

prs

Parameters

sIndent

arg

number object

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

hour

name

hour(arg)

des

sIndent

Create hour(date) expression

prs

Parameters

sIndent

arg

date object

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

len

name

len(value)

des

sIndent

Create length(column) expression

prs

Parameters

sIndent

value

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

locate

name

locate(string1, string2)

des

sIndent

Create locate(str1, str2) expression

prs

Parameters

sIndent

string1

string to locate

string2

string to search in

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

locate

name

locate(string1, string2, start)

des

sIndent

Create locate(str1, str2, start) expression

prs

Parameters

sIndent

string1

string to locate

string2

string to search in

start

start pos

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

lower

name

lower(value)

des

sIndent

Create lower(column) expression

prs

Parameters

sIndent

value

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

minus

name

minus(arg1, arg2)

des

sIndent

Create minus(args, arg2) expression

prs

Parameters

sIndent

arg1

;

arg2

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

minute

name

minute(arg)

des

sIndent

Create minute(date) expression

prs

Parameters

sIndent

arg

date object

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

mod

name

mod(dividend, divisor)

des

sIndent

Create mod(dividend, divisor) expression

prs

Parameters

sIndent

dividend

;

divisor

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

month

name

month(arg)

des

sIndent

Create month(date) expression

prs

Parameters

sIndent

arg

date object

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

multiply

name

multiply(arg1, arg2)

des

sIndent

Create multiply(args, arg2) expression

prs

Parameters

sIndent

arg1

;

arg2

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

nullif

name

nullif(arg1)

des

sIndent

Create nullif(arg1, arg2) expression

prs

Parameters

sIndent

arg1

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

plus

name

plus(arg1, arg2)

des

sIndent

Create plus(args, arg2) expression

prs

Parameters

sIndent

arg1

;

arg2

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

round

name

round(arg)

des

sIndent

Create round(column) expression

prs

Parameters

sIndent

arg

number object

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

round

name

round(arg, decimals)

des

sIndent

Create round(column) expression

prs

Parameters

sIndent

arg

number object

decimals

The number of decimal places to round number to, default 0

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

second

name

second(arg)

des

sIndent

Create second(date) expression

prs

Parameters

sIndent

arg

date object

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

sqrt

name

sqrt(value)

des

sIndent

Create sqrt(column) expression

prs

Parameters

sIndent

value

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

substring

name

substring(arg, pos)

des

sIndent

Create substring(column, pos) expression

prs

Parameters

sIndent

arg

column name

pos

position

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

substring

name

substring(arg, pos, len)

des

sIndent

Create substring(column, pos, len) expression

prs

Parameters

sIndent

arg

column name

pos

position

len

length

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

trim

name

trim(value)

des

sIndent

Create trim(column) expression

prs

Parameters

sIndent

value

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

trim

name

trim(leading_trailing_both, characters, fromKeyword, value)

des

sIndent

Create trim([leading | trailing | both] [characters] from column)

prs

Parameters

sIndent

leading_trailing_both

'leading', 'trailing' or 'both'

characters

characters to remove

fromKeyword

'from'

value

value to trim

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

upper

name

upper(value)

des

sIndent

Create upper(column) expression

prs

Parameters

sIndent

value

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

year

name

year(arg)

des

sIndent

Create year(date) expression

prs

Parameters

sIndent

arg

date object

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

Child pages

Page History

Versions Compared

Old Version 10

New Version Current

Key

root

abs

bit_length

cast

ceil

coalesce

concat

day

divide

floor

hour

len

locate

locate

lower

minus

minute

mod

month

multiply

nullif

plus

round

second

sqrt

substring

substring

trim

upper

year

parent

parent

root

abs(value)

bit_length(value)

cast(value, type)

ceil(arg)

coalesce(args)

concat(arg1, arg2)

custom(name, args)

day(arg)

divide(arg1, arg2)

floor(arg)

hour(arg)

len(value)

locate(string1, string2)

locate(string1, string2, start)

lower(value)

minus(arg1, arg2)

minute(arg)

mod(dividend, divisor)

month(arg)

multiply(arg1, arg2)

nullif(arg1)

plus(arg1, arg2)

round(arg)

round(arg, decimals)

second(arg)

sqrt(value)

substring(arg, pos)

substring(arg, pos, len)

trim(value)

trim(leading_trailing_both, characters, fromKeyword, value)

upper(value)

year(arg)