Page History

Divcache

Div

id	description

HTML Table

id

class

servoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)abs

indexstyle	true	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.

refresh	100d
showRefresh	true
id	doc
title	Refresh page
showDate	true
retry	Enable

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Property SummaryCreate abs(column) expression Table Row (tr)

Table Cell (td)
QBSort

Table Cell (td)asc

Table Cell (td)avg

Create an ascending sort expression

Table Row (tr)

Table Cell (td)
QBAggregate

Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)bit_length

Table Cell (td)
QBFunction

Table Cell (td)ceil

Create bit_length(column) expression

Table Row (tr)

Create ceil(column) expression

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)count

Table Cell (td)day

Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBFunction

Extract day from date

Table Row (tr)

Table Cell (td)
QBSort

Table Cell (td)desc

Table Cell (td)floor

Create an descending sort expression

Table Row (tr)

Table Cell (td)
QBFunction

Create floor(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
hour Extract hour from date

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)isNull

Table Cell (td)len

Extract hour from date

Compare column with null.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)lower

Create length(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

Create lower(column) expression

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)max

min

Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)

month

Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
minute Extract minute from date

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)

Extract minute from date

Extract month from date

Table Row (tr)

Table Cell (td)
QBColumn

Table Cell (td)not

Create a negated condition.

Table Row (tr)

Table Cell (td)
QBTableClause

Table Cell (td)parent
Table Row (tr)

Table Cell (td)
QBSelect

Table Cell (td)root

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

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)round

Get query builder parent.

second

Create round(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)

Extract second from date

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)sum

Table Cell (td)trim

Create sqrt(column) expression

Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)upper

Create trim(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

Create upper(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)year

Extract year from date

HTML Tableidclassservoy 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)
QBCondition

Table Cell (td)between(value1, value2)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)cast(type)

servoy sSummary

12%

30%

58%

height: 30px;

3

Methods Summary

Compare column to a range of 2 values or other columns.

Create cast(column, type) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
concat(arg) Concatename with value

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
divide(arg) Divide by value

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)eq(value)
Compare Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)ge(value)

Concatename with value

Divide by value

Compare column with a value or another column.

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
gt(value) Compare column with a value or another column.

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)isin(query)
Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)isin(values)

The flags are a bit pattern consisting of 1 or more of the following bits: - JSColumn.

Column type as a string

Compare column with a value or another column.

Compare column with subquery result.

Compare column with values.

Compare column with

values. Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)le(value)
Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)like(pattern)
Compare column with

custom query result.

Compare column with a value or another column.

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)like(pattern, escape)
Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)locate

Create locate(arg) expression

Create locate(arg, start) expression

Compare column with a value or another column.

Subtract value

Create mod(arg)

Create locate

expression

Multiply with value

Create nullif(arg) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
locate(arg, start) Create locate(arg, start) expression

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
lt(value) Compare column with a value or another column.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
minus(arg) Subtract value

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
mod(arg) Create mod(arg) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
multiply(arg) Multiply with value

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
nullif(arg) Create nullif(arg) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
plus(arg) Add up value

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
substring(pos) Create substring(pos) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
substring(pos, len) Create substring(pos, len) 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	abs

Table Row (tr)

id	name

Table Cell (td)
abs

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create abs(column) expression

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

query.result.add(query.columns.custname.abs)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	asc

Table Row (tr)

id	name

Table Cell (td)
asc

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create an ascending sort expression

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBSort

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')
query.sort
.add(query.joins.orders_to_order_details.columns.quantity.asc)
.add(query.columns.companyid)
foundset.loadRecords(query)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	avg

Table Row (tr)

id	name

Table Cell (td)
avg

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create an aggregate expression.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBAggregate

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')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.avg.eq(1))
	foundset.loadRecords(query)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	bit_length

Table Row (tr)

id	name

Table Cell (td)
bit_length

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create bit_length(column) expression

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

query.result.add(query.columns.custname.bit_length)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	ceil

Table Row (tr)

id	name

Table Cell (td)
ceil

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create ceil(column) expression

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

query.result.add(query.columns.mycol.ceil)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	count

Table Row (tr)

id	name

Table Cell (td)
count

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create an aggregate expression.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBAggregate

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')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.eq(0))
	foundset.loadRecords(query)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	day

Table Row (tr)

id	name

Table Cell (td)
day

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Extract day from date

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

query.result.add(query.columns.mydatecol.day)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	desc

Table Row (tr)

id	name

Table Cell (td)
desc

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create an descending sort expression

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBSort

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')
query.sort
.add(query.joins.orders_to_order_details.columns.quantity.desc)
.add(query.columns.companyid)
foundset.loadRecords(query)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	floor

Table Row (tr)

id	name

Table Cell (td)
floor

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create floor(column) expression

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

query.result.add(query.columns.mycol.floor)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	hour

Table Row (tr)

id	name

Table Cell (td)
hour

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Extract hour from date

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

query.result.add(query.columns.mydatecol.hour)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	isNull

Table Row (tr)

id	name

Table Cell (td)
isNull

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Compare column with null.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

query.where.add(query.columns.flag.isNull)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	len

Table Row (tr)

id	name

Table Cell (td)
len

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create length(column) expression

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

query.result.add(query.columns.custname.len)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	lower

Table Row (tr)

id	name

Table Cell (td)
lower

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create lower(column) expression

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

query.result.add(query.columns.custname.lower)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	max

Table Row (tr)

id	name

Table Cell (td)
max

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create an aggregate expression.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBAggregate

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')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.max(10))
	foundset.loadRecords(query)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	min

Table Row (tr)

id	name

Table Cell (td)
min

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create an aggregate expression.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBAggregate

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')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.min(10))
	foundset.loadRecords(query)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	minute

Table Row (tr)

id	name

Table Cell (td)
minute

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Extract minute from date

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

query.result.add(query.columns.mydatecol.minute)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	month

Table Row (tr)

id	name

Table Cell (td)
month

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Extract month from date

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

query.result.add(query.columns.mydatecol.month)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	not

Table Row (tr)

id	name

Table Cell (td)
not

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create a negated condition.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBColumn

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

query.where.add(query.columns.flag.not.eq(1))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

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

QBTableClause

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)

Table Body (tbody)

id	round

Table Row (tr)

id	name

Table Cell (td)
round

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create round(column) expression

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

query.result.add(query.columns.mycol.round)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	second

Table Row (tr)

id	name

Table Cell (td)
second

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Extract second from date

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

query.result.add(query.columns.mydatecol.second)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	sqrt

Table Row (tr)

id	name

Table Cell (td)
sqrt

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create sqrt(column) expression

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

query.result.add(query.columns.custname.sqrt)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	sum

Table Row (tr)

id	name

Table Cell (td)
sum

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create an aggregate expression.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBAggregate

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')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.sum(10))
	foundset.loadRecords(query)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	trim

Table Row (tr)

id	name

Table Cell (td)
trim

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create trim(column) expression

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

query.result.add(query.columns.custname.trim)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	upper

Table Row (tr)

id	name

Table Cell (td)
upper

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create upper(column) expression

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

query.result.add(query.columns.custname.upper)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	year

Table Row (tr)

id	name

Table Cell (td)
year

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Extract year from date

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

query.result.add(query.columns.mydatecol.year)

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

Table Row (tr)

id	name

Table Cell (td)
between

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

between

Span
(value1, value2)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Compare column to a range of 2 values or other columns.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} value1
{Object} value2

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

query.where.add(query.columns.flag.between(0, 5))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	cast-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
(type)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create cast(column, type) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} type - string 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

query.result.add(query.columns.mycol.cast(QUERY_COLUMN_TYPES.TYPE_INTEGER))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	concat-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
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Concatename with value

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg - valeu to concatenate with

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

query.result.add(query.columns.firstname.concat(' ').concat(query.columns.lastname))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	divide-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
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Divide by value

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg - nr to divide by

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

query.result.add(query.columns.mycol.divide(2))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	eq-Object

Table Row (tr)

id	name

Table Cell (td)
eq

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

eq

Span
(value)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Compare column with a value or another column.
Operator: equals

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

QBCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

query.where.add(query.columns.flag.eq(1))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	ge-Object

Table Row (tr)

id	name

Table Cell (td)
ge

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

ge

Span
(value)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Compare column with a value or another column.
Operator: greaterThanOrEqual

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

QBCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

query.where.add(query.columns.flag.ge(2))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	gt-Object

Table Row (tr)

id	name

Table Cell (td)
gt

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

gt

Span
(value)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Compare column with a value or another column.
Operator: greaterThan

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

QBCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

query.where.add(query.columns.flag.gt(0))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	isin-QBPart

Table Row (tr)

id	name

Table Cell (td)
isin

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

isin

Span
(query)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Compare column with subquery result.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{QBPart} query - subquery

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

query.where.add(query.columns.flag.isin(query2))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	isin-ObjectArray

Table Row (tr)

id	name

Table Cell (td)
isin

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

isin

Span
(values)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Compare column with values.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object[]} values - array of values

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

query.where.add(query.columns.flag.isin([1, 5, 99]))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	le-Object

Table Row (tr)

id	name

Table Cell (td)
le

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

le

Span
(value)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Compare column with a value or another column.
Operator: lessThanOrEqual

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

QBCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

query.where.add(query.columns.flag.le(2))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	like-String

Table Row (tr)

id	name

Table Cell (td)
like

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

like

Span
(pattern)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Compare column with a value or another column.
Operator: like

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} pattern - the string value of the pattern

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

query.where.add(query.columns.companyname.like('Serv%'))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	like-String_String

Table Row (tr)

id	name

Table Cell (td)
like

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

like

Span
(pattern, escape)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Compare column with a value or another column.
Operator: like, with escape character

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} pattern - the string value of the pattern
{String} escape - the escape char

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

query.where.add(query.columns.companyname.like('X_%', '_'))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	locate-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
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create locate(arg) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg - string to locate

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

query.result.add(query.columns.mycol.locate('sample'))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	locate-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
(arg, start)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create locate(arg, start) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg - string to locate
{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

query.result.add(query.columns.mycol.locate('sample', 5))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	lt-Object

Table Row (tr)

id	name

Table Cell (td)
lt

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

lt

Span
(value)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Compare column with a value or another column.
Operator: lessThan

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

QBCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

query.where.add(query.columns.flag.lt(99))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	minus-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
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Subtract value

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg - nr to subtract

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

query.result.add(query.columns.mycol.minus(2))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	mod-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
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create mod(arg) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg - mod arg

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

query.result.add(query.columns.mycol.mod(2))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	multiply-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
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Multiply with value

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg - nr to multiply with

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

query.result.add(query.columns.mycol.multiply(2))

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

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create nullif(arg) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg - object to compare

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

query.result.add(query.columns.mycol.nullif('none'))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	plus-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
(arg)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Add up value

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Object} arg - nr to add

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

query.result.add(query.columns.mycol.plus(2))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	substring-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
(pos)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create substring(pos) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Number} 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

query.result.add(query.columns.mycol.substring(3))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	substring-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
(pos, len)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create substring(pos, len) expression

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Number} pos
{Number} len

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

query.result.add(query.columns.mycol.substring(3, 2))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Add up value

Create substring(pos) expression

Create substring(pos, len) expression

propertyservoy sDetail2100%height:30px2Property Detailsabsname

abs

des

sIndent

Create abs(column) expression

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

asc

name

asc

des

sIndent

Create an ascending sort expression

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

avg

name

avg

des

sIndent

Create an aggregate expression.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

bit_length

name

bit_length

des

sIndent

Create bit_length(column) expression

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

ceil

name

ceil

des

sIndent

Create ceil(column) expression

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

count

name

count

des

sIndent

Create an aggregate expression.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

day

name

day

des

sIndent

Extract day from date

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

desc

name

desc

des

sIndent

Create an descending sort expression

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

floor

name

floor

des

sIndent

Create floor(column) expression

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

hour

name

hour

des

sIndent

Extract hour from date

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

isNull

name

isNull

des

sIndent

Compare column with null.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

len

name

len

des

sIndent

Create length(column) expression

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

lower

name

lower

des

sIndent

Create lower(column) expression

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

max

name

max

des

sIndent

Create an aggregate expression.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

min

name

min

des

sIndent

Create an aggregate expression.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

minute

name

minute

des

sIndent

Extract minute from date

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

month

name

month

des

sIndent

Extract month from date

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

not

name

not

des

sIndent

Create a negated condition.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

parent

name

parent

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

root

name

root

des

sIndent

Get query builder parent.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

round

name

round

des

sIndent

Create round(column) expression

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

second

name

second

des

sIndent

Extract second from date

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

sqrt

name

sqrt

des

sIndent

Create sqrt(column) expression

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

sum

name

sum

des

sIndent

Create an aggregate expression.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

trim

name

trim

des

sIndent

Create trim(column) expression

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

upper

name

upper

des

sIndent

Create upper(column) expression

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

year

name

year

des

sIndent

Extract year from date

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

functionservoy sDetail2100%height:30px2Methods Detailsbetweenname

between(value1, value2)

des

sIndent

Compare column to a range of 2 values or other columns.

prs

Parameters

sIndent

value1

;

value2

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

cast

name

cast(type)

des

sIndent

Create cast(column, type) expression

prs

Parameters

sIndent

type

string type, see QUERY_COLUMN_TYPES

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

concat

name

concat(arg)

des

sIndent

Concatename with value

prs

Parameters

sIndent

arg

valeu to concatenate with

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

divide

name

divide(arg)

des

sIndent

Divide by value

prs

Parameters

sIndent

arg

nr to divide by

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

eq

name

eq(value)

des

sIndent

Compare column with a value or another column.
Operator: equals

prs

Parameters

sIndent

value

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

ge

name

ge(value)

des

sIndent

Compare column with a value or another column.
Operator: greaterThanOrEqual

prs

Parameters

sIndent

value

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getFlags

name

getFlags()

des

sIndent

The flags are a bit pattern consisting of 1 or more of the following bits:
 - JSColumn.UUID_COLUMN
 - JSColumn.EXCLUDED_COLUMN
 - JSColumn.TENANT_COLUMN

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getTypeAsString

name

getTypeAsString()

des

sIndent

Column type as a string

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

gt

name

gt(value)

des

sIndent

Compare column with a value or another column.
Operator: greaterThan

prs

Parameters

sIndent

value

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

isin

name

isin(query)

des

sIndent

Compare column with subquery result.

prs

Parameters

sIndent

query

subquery

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

isin

name

isin(values)

des

sIndent

Compare column with values.

prs

Parameters

sIndent

values

array of values

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

isin

name

isin(customQuery, args)

des

sIndent

Compare column with custom query result.

prs

Parameters

sIndent

customQuery

custom query

args

query arguments

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

le

name

le(value)

des

sIndent

Compare column with a value or another column.
Operator: lessThanOrEqual

prs

Parameters

sIndent

value

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

like

name

like(pattern)

des

sIndent

Compare column with a value or another column.
Operator: like

prs

Parameters

sIndent

pattern

the string value of the pattern

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

like

name

like(pattern, escape)

des

sIndent

Compare column with a value or another column.
Operator: like, with escape character

prs

Parameters

sIndent

pattern

the string value of the pattern

escape

the escape char

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

locate

name

locate(arg)

des

sIndent

Create locate(arg) expression

prs

Parameters

sIndent

arg

string to locate

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

locate

name

locate(arg, start)

des

sIndent

Create locate(arg, start) expression

prs

Parameters

sIndent

arg

string to locate

start

start pos

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

lt

name

lt(value)

des

sIndent

Compare column with a value or another column.
Operator: lessThan

prs

Parameters

sIndent

value

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

minus

name

minus(arg)

des

sIndent

Subtract value

prs

Parameters

sIndent

arg

nr to subtract

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

mod

name

mod(arg)

des

sIndent

Create mod(arg) expression

prs

Parameters

sIndent

arg

mod arg

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

multiply

name

multiply(arg)

des

sIndent

Multiply with value

prs

Parameters

sIndent

arg

nr to multiply with

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

nullif

name

nullif(arg)

des

sIndent

Create nullif(arg) expression

prs

Parameters

sIndent

arg

object to compare

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

plus

name

plus(arg)

des

sIndent

Add up value

prs

Parameters

sIndent

arg

nr to add

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

substring

name

substring(pos)

des

sIndent

Create substring(pos) expression

prs

Parameters

sIndent

pos

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

substring

name

substring(pos, len)

des

sIndent

Create substring(pos, len) expression

prs

Parameters

sIndent

pos

;

len

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

Child pages

Page History

Versions Compared

Old Version 14

New Version Current

Key

abs

asc

avg

bit_length

ceil

count

day

desc

floor

hour

isNull

len

lower

max

min

minute

month

not

parent

root

round

second

sqrt

sum

trim

upper

year

between

cast

concat

divide

eq

ge

gt

isin

isin

le

like

like

locate

locate

lt

minus

mod

multiply

nullif

plus

substring

substring

abs

asc

avg

bit_length

ceil

count

day

desc

floor

hour

isNull

len

lower

max

min

minute

month

not

parent

root

round

second

sqrt

sum

trim