Page History

Div

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

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

id
class	servoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
bit_length(value) Create bit_length(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
cast(value, type) Cast using type name.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
ceil(arg) Create ceil(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
concat(arg1, arg2) Create concat(args, arg2) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
day(arg) Create day(date) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
divide(arg1, arg2) Create divide(args, arg2) expression

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
hour(arg) Create hour(date) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
len(value) Create length(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
minus(arg1, arg2) Create minus(args, arg2) expression

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

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

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

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

Table Cell (td)

Child pages

Versions Compared

Old Version 13

New Version Current

Key

parent

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