Page History

{div:style=}

Wiki Markup

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.\\ \\ Enter additional information related to this 'class' inside the \{div} macro with 'id=description'{div} {div:id=description}{div}\\ {table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Property Summary{th}{tr}{tbody}{tr}{td}[QBSelect]{td}{td}[#parent] Get query builder parent table clause, this may be a query or a join clause.{td}{tr}{tbody}{tbody}{tr}{td}[QBSelect]{td}{td}[#root] Get query builder parent.{td}{tr}{tbody}{table}\\ {table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tr}{td}[QBFunction]{td}{td}[#abs]\(value) Create abs(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#bit_length]\(value) Create bit\_length(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#cast]\(value, type) Cast using type name.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#ceil]\(arg) Create ceil(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#coalesce]\(args) Create year(date) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#concat]\(arg1, arg2) Create concat(args, arg2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#day]\(arg) Create day(date) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#divide]\(arg1, arg2) Create divide(args, arg2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#floor]\(arg) Create floor(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#hour]\(arg) Create hour(date) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#len]\(value) Create length(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#locate]\(string1, string2) Create locate(str1, str2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#locate]\(string1, string2, start) Create locate(str1, str2, start) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#lower]\(value) Create lower(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#minus]\(arg1, arg2) Create minus(args, arg2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#minute]\(arg) Create minute(date) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#mod]\(dividend, divisor) Create mod(dividend, divisor) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#month]\(arg) Create month(date) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#multiply]\(arg1, arg2) Create multiply(args, arg2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#nullif]\(arg1) Create nullif(arg1, arg2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#plus]\(arg1, arg2) Create plus(args, arg2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#round]\(arg) Create round(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#second]\(arg) Create second(date) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#sqrt]\(value) Create sqrt(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#substring]\(arg, pos) Create substring(column, pos) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#substring]\(arg, pos, len) Create substring(column, pos, len) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#trim]\(value) Create trim(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#upper]\(value) Create upper(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#year]\(arg) Create year(date) expression{td}{tr}{tbody}{table}\\ {table:id=property|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Property Details{th}{tr}{tbody:id=parent}{tr:id=name}{td}h6.parent{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBSelect]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=root}{tr:id=name}{td}h6.root{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBSelect]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ {table:id=function|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=abs-Object}{tr:id=name}{td}h6.abs{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}abs{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

))
		)

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	bit_length-Object

}{

Table Row (tr)

:

id

=

	name

}{td}h6.

Table Cell (td)
bit_length

{td}{tr}{tr:id=sig}{td}{span:style=

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=font-weight: bold;}bit_length{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	cast-Object_String

}{

Table Row (tr)

:

id

=

	name

}{td}h6.cast{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
cast

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}

cast

{span}{span}\

Span
(value,

type)

{span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value -- object to cast \{[String]} type -- type see QUERY\_COLUMN\_TYPES {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=ceil-Object}{tr:id=name}{td}h6.ceil{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}ceil{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- number object {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=coalesce-ObjectArray}{tr:id=name}{td}h6.coalesce{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}coalesce{span}{span}\(args){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]...} args -- arguments to coalesce {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	concat-Object_Object

}{

Table Row (tr)

:

id

=

	name

}{td}h6.concat{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
concat

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}

concat

{span}{span}\

Span
(arg1,

arg2)

{span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg1 \{[Object]} arg2 {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=day-Object}{tr:id=name}{td}h6.day{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}day{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- date object {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	divide-Object_Object

}{

Table Row (tr)

:

id

=name}{td}h6.divide{td}{tr}{tr:id=sig}{td}{span:style=

	name

Table Cell (td)
divide

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}

divide

{span}{span}\

Span
(arg1,

arg2)

{span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg1 \{[Object]} arg2 {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=floor-Object}{tr:id=name}{td}h6.floor{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}floor{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- number object {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=hour-Object}{tr:id=name}{td}h6.hour{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}hour{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- date object {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=len-Object}{tr:id=name}{td}h6.len{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}len{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	locate-Object_Object

}{

Table Row (tr)

:

id

=

	name

}{td}h6.locate{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
locate

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}

locate

{span}{span}\

Span
(string1,

string2)

{span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} string1 -- string to locate \{[Object]} string2 -- string to search in {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	locate-Object_Object_Number

}{

Table Row (tr)

:

id

=

	name

}{td}h6.locate{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
locate

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}

locate

{span}{span}\

Span
(string1,

string2,

start)

{span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} string1 -- string to locate \{[Object]} string2 -- string to search in \{[Number]} start -- start pos {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=lower-Object}{tr:id=name}{td}h6.lower{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}lower{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	minus-Object_Object

}{

Table Row (tr)

:

id

=

	name

}{td}h6.minus{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
minus

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}

minus

{span}{span}\

Span
(arg1,

arg2)

{span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg1 \{[Object]} arg2 {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minute-Object}{tr:id=name}{td}h6.minute{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}minute{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- date object {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	mod-Object_Object

}{

Table Row (tr)

:

id

=

	name

}{td}h6.mod{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
mod

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}

mod

{span}{span}\

Span
(dividend,

divisor)

{span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} dividend \{[Object]} divisor {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=month-Object}{tr:id=name}{td}h6.month{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}month{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- date object {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	multiply-Object_Object

}{

Table Row (tr)

:

id

=

	name

}{td}h6.multiply{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
multiply

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}

multiply

{span}{span}\

Span
(arg1,

arg2)

{span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg1 \{[Object]} arg2 {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=nullif-Object}{tr:id=name}{td}h6.nullif{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}nullif{span}{span}\(arg1){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg1 {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	plus-Object_Object

}{

Table Row (tr)

:

id

=

	name

}{td}h6.plus{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
plus

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}

plus

{span}{span}\

Span
(arg1,

arg2)

{span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg1 \{[Object]} arg2 {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=round-Object}{tr:id=name}{td}h6.round{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}round{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- number object {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=second-Object}{tr:id=name}{td}h6.second{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}second{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- date object {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sqrt-Object}{tr:id=name}{td}h6.sqrt{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}sqrt{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	substring-Object_Number

}{

Table Row (tr)

:

id

=

	name

}{td}h6.substring{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
substring

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}

substring

{span}{span}\

Span
(arg,

pos)

{span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- column name \{[Number]} pos -- position {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	substring-Object_Number_Number

}{

Table Row (tr)

:

id

=

	name

}{td}h6.substring{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
substring

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}substring{span}{span}\

substring

Span
(arg,

pos,

len)

{span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- column name \{[Number]} pos -- position \{[Number]} len -- length {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=trim-Object}{tr:id=name}{td}h6.trim{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}trim{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=upper-Object}{tr:id=name}{td}h6.upper{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}upper{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=year-Object}{tr:id=name}{td}h6.year{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}year{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- date object {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 6

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