Page History

...

style	display:none

...

id	description

...

padding	0px
width	80px

...

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBSort

Table Cell (td)
#asc Create an ascending sort expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)
#avg Create an aggregate expression.

...

Table Cell (td)
QBFunction

...

Table Cell (td)
QBFunction

...

Cache

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

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Property SummaryCreate abs(column) expressionCreate an ascending sort expressionCreate an aggregate expression.Create bit_length(column) expression

...

Table Cell (td)
QBFunction

...

Create ceil(column) expression

...

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)
#count Create an aggregate expression.

Table Cell (td)
QBSort

...

Create an aggregate expression.

Extract day from date

...

Table Cell (td)
QBFunction

...

Create an descending sort expression

...

Create floor(column) expression

...

Table Cell (td)
QBFunction

...

Table Cell (td)
QBFunction

...

Extract hour from date

...

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
#isNull Compare column with null.

...

Table Cell (td)
QBFunction

...

Compare column with null.

Create length(column) expression

...

Create lower(column) expression

...

Table Cell (td)
QBAggregate

...

Table Cell (td)
QBAggregate

...

Create an aggregate expression.

...

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#minute Extract minute from date

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#month Extract month from date

...

Table Cell (td)
QBColumn

...

Create an aggregate expression.

...

Extract minute from date

Extract month from date

Create a negated condition.

...

Table Cell (td)
QBTableClause

...

Table Cell (td)
QBSelect

...

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

...

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

...

Table Cell (td)
QBFunction

...

Get query builder parent.

...

Table Cell (td)
QBFunction

...

Create round(column) expression

Extract second from date

...

Create sqrt(column) expression

...

Table Cell (td)
QBAggregate

...

Table Cell (td)
QBFunction

...

Create an aggregate expression.

...

Create trim(column) expression

...

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#year Extract year from date

...

padding	0px
width	80px

...

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
#between(value1, value2) Compare column to a range of 2 values or other columns.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#cast(type) Create cast(column, type) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

...

Table Cell (td)
QBCondition

...

Table Cell (td)
QBCondition

...

Create upper(column) expression

Extract year from date

servoy sSummary12%30%58%height: 30px;3Methods SummaryCompare column to a range of 2 values or other columns.Create cast(column, type) expressionConcatename with valueDivide by valueCompare column with a value or another column.Compare column with a value or another column.The flags are a bit pattern consisting of 1 or more of the following bits: - JSColumn.Column type as a stringCompare column with a value or another column.Compare column with subquery result.Compare column with values.Compare column with custom query result.Compare column with a value or another column.

...

Table Cell (td)
QBCondition

...

Compare column with a value or another column.

...

Table Row (tr)

id	name

Table Cell (td)
root

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get query builder parent.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBSelect

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript


/** @type {QBSelect<db:/example_data/order_details>} */
	var subquery = databaseManager.createSelect('db:/example_data/order_details')
	
 /** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.where.add(query
		.or 
			.add(query.columns.order_id.not.isin([1, 2, 3]))
			
			.add(query.exists(
					subquery.where.add(subquery.columns.orderid.eq(query.columns.order_id)).root
			))
		)
		
	foundset.loadRecords(query)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

HTML Table

id	function
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Method Details

Table Body (tbody)

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

...

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
#isin(query) Compare column with subquery result.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
#isin(values) Compare column with values.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBCondition

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
#like(pattern) Compare column with a value or another column.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
#like(pattern, escape) Compare column with a value or another column.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#locate(arg) Create locate(arg) expression

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBCondition

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
#minus(arg) Subtract value

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunction

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

...

id	property
class	servoy sDetail

...

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Property Details

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

id	root

Create locate(arg) expression

Create locate(arg, start) expression

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

td

Subtract value

Create mod(arg) expression

Multiply with value

Create nullif(arg) expression

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 10

New Version Current

Key

root

round

second

sqrt

sum

trim

upper

year

between

cast

concat

divide

eq

ge

gt

isin

isin

le

like

abs

asc

avg

bit_length

ceil

count

day

desc

floor

hour

isNull

len

lower

max

min

minute

month

not

parent

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