Page History

...

HTML Table

id
class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBSelect

Table Cell (td)
#parent parent Get query builder parent table clause, this may be a query or a join clause.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBSelect

Table Cell (td)
#root root Get query builder parent.

HTML Table

id
class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

tbody

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

tbody

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

tbody

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

HTML Table

id	property
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

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

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

Table Cell (td)

Child pages

Versions Compared

Old Version 10

New Version 11

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