Page History

{div:style=}

Wiki Markup

Div

style	display:none

DO

NOT

EDIT

THE

CONTENT

OF

THIS

PAGE

DIRECTLY

(EXCEPT

INSIDE

THE

DIV

BELOW

WITH

ID=DESCRIPTION),

UNLESS

YOU

KNOW

WHAT

YOU'RE

DOING.

THE

STRUCTURE

OF

THE

CONTENT

IS

VITAL

IN

BEING

ABLE

TO

AUTO

UPDATE

THE

CONTENT

THROUGH

THE

DOC

GENERATOR.\\ \\ Enter additional information related to this 'class' inside the \{div} macro with 'id=description'{div} {div:id=description}{div}\\ {table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Property Summary{th}{tr}{tbody}{tr}{td}[QBFunction]{td}{td}[#abs] Create abs(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBSort]{td}{td}[#asc] Create an ascending sort expression{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#avg] Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#bit_length] Create bit\_length(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#ceil] Create ceil(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#count] Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#day] Extract day from date{td}{tr}{tbody}{tbody}{tr}{td}[QBSort]{td}{td}[#desc] Create an descending sort expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#floor] Create floor(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#hour] Extract hour from date{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#isNull] Compare column with null.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#len] Create length(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#lower] Create lower(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#max] Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#min] Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#minute] Extract minute from date{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#month] Extract month from date{td}{tr}{tbody}{tbody}{tr}{td}[QBColumn]{td}{td}[#not] Create a negated condition.{td}{tr}{tbody}{tbody}{tr}{td}[QBTableClause]{td}{td}[#parent] Get query builder parent table clause, this may be a query or a join clause.{td}{tr}{tbody}{tbody}{tr}{td}[QBSelect]{td}{td}[#root] Get query builder parent.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#round] Create round(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#second] Extract second from date{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#sqrt] Create sqrt(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#sum] Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#trim] Create trim(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#upper] Create upper(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#year] Extract year from date{td}{tr}{tbody}{table}\\ {table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tr}{td}[QBCondition]{td}{td}[#between]\(value1, value2) Compare column to a range of 2 values or other columns.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#cast]\(type) Create cast(column, type) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#concat]\(arg) Concatename with value{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#divide]\(arg) Divide by value{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#eq]\(value) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#ge]\(value) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#gt]\(value) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#isin]\(query) Compare column with subquery result.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#isin]\(values) Compare column with values.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#le]\(value) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#like]\(pattern) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#like]\(pattern, escape) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#locate]\(arg) Create locate(arg) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#locate]\(arg, start) Create locate(arg, start) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#lt]\(value) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#minus]\(arg) Subtract value{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#mod]\(arg) Create mod(arg) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#multiply]\(arg) Multiply with value{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#nullif]\(arg) Create nullif(arg) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#plus]\(arg) Add up value{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#substring]\(pos) Create substring(pos) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#substring]\(pos, len) Create substring(pos, len) expression{td}{tr}{tbody}{table}\\ {table:id=property|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Property Details{th}{tr}{tbody:id=abs}{tr:id=name}{td}h6.abs{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create abs(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

GENERATOR.

Div

id	description

HTML Table

id
class	servoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBSort

Table Cell (td)
asc Create an ascending sort expression

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)
avg Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)
count Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
day Extract day from date

Table Row (tr)

Table Cell (td)
QBSort

Table Cell (td)
desc Create an descending sort expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
floor 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 Compare column with null.

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)
max Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)
min 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)
month 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 Get query builder parent table clause, this may be a query or a join clause.

Table Row (tr)

Table Cell (td)
QBSelect

Table Cell (td)
root Get query builder parent.

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
second 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 Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

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

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
year Extract year from date

HTML Table

id
class	servoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Row (tr)

Table Cell (td)
QBCondition

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

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
cast(type) 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 column with a value or another column.

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
ge(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) Compare column with subquery result.

Table Row (tr)

Table Cell (td)
QBCondition

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

Table Row (tr)

Table Cell (td)
QBCondition

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

Table Row (tr)

Table Cell (td)
QBCondition

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

Table Row (tr)

Table Cell (td)
QBCondition

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

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
locate(arg) Create locate(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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=asc}{tr:id=name}{td}h6.asc{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an ascending sort expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBSort]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	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) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=avg}{tr:id=name}{td}h6.avg{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an aggregate expression.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=bit_length}{tr:id=name}{td}h6.bit_length{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create bit\

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{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=ceil}{tr:id=name}{td}h6.ceil{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create ceil(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	ceil

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=count}{tr:id=name}{td}h6.count{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an aggregate expression.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=day}{tr:id=name}{td}h6.day{td}{tr}{tr:id=des}{td}{div:class=sIndent}Extract day from date{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	day

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=desc}{tr:id=name}{td}h6.desc{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an descending sort expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBSort]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=floor}{tr:id=name}{td}h6.floor{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create floor(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	floor

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=hour}{tr:id=name}{td}h6.hour{td}{tr}{tr:id=des}{td}{div:class=sIndent}Extract hour from date{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	hour

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isNull}{tr:id=name}{td}h6.isNull{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with null.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	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) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=len}{tr:id=name}{td}h6.len{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create length(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=lower}{tr:id=name}{td}h6.lower{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create lower(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	lower

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=max}{tr:id=name}{td}h6.max{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an aggregate expression.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=min}{tr:id=name}{td}h6.min{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an aggregate expression.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minute}{tr:id=name}{td}h6.minute{td}{tr}{tr:id=des}{td}{div:class=sIndent}Extract minute from date{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	minute

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=month}{tr:id=name}{td}h6.month{td}{tr}{tr:id=des}{td}{div:class=sIndent}Extract month from date{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	month

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=not}{tr:id=name}{td}h6.not{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create a negated condition.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBColumn]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=parent}{tr:id=name}{td}h6.parent{td}{tr}{tr:id=des}{td}{div:class=sIndent}Get query builder parent table clause, this may be a query or a join clause.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBTableClause]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	root

Table Row (tr)

id	name

Table Cell (td)
root

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get query builder parent.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBSelect

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @type {QBSelect<db:/example_data/order_details>} */
	var subquery = databaseManager.createSelect('db:/example_data/order_details')


 /** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.where.add(query
		.or

			.add(query.columns.order_id.not.isin([1, 2, 3]))


			.add(query.exists(
					subquery.where.add(subquery.columns.orderid.eq(query.columns.order_id)).root
			))
		)


	foundset.loadRecords(query)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=round}{tr:id=name}{td}h6.round{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create round(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	round

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=second}{tr:id=name}{td}h6.second{td}{tr}{tr:id=des}{td}{div:class=sIndent}Extract second from date{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	second

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sqrt}{tr:id=name}{td}h6.sqrt{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create sqrt(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	sqrt

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sum}{tr:id=name}{td}h6.sum{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an aggregate expression.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=trim}{tr:id=name}{td}h6.trim{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create trim(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	trim

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=upper}{tr:id=name}{td}h6.upper{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create upper(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	upper

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=year}{tr:id=name}{td}h6.year{td}{tr}{tr:id=des}{td}{div:class=sIndent}Extract year from date{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	year

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)

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ {table:id=function|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=between-Object_Object}{tr:id=name}{td}h6.between{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}between{span}{span}\(value1, value2){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column to a range of 2 values or other columns.{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value1 \{[Object]} value2 {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=cast-String}{tr:id=name}{td}h6.cast{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}cast{span}{span}\(type){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create cast(column, type) expression{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[String]} type -- string type, see QUERY\_COLUMN\_TYPES {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

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

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	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)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=divide-Object}{tr:id=name}{td}h6.divide{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}divide{span}{span}\(arg){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Divide by value{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- nr to divide by {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=eq-Object}{tr:id=name}{td}h6.eq{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}eq{span}{span}\(value){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column. Operator: equals{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=ge-Object}{tr:id=name}{td}h6.ge{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}ge{span}{span}\(value){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column. Operator: greaterThanOrEqual{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	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)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=gt-Object}{tr:id=name}{td}h6.gt{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}gt{span}{span}\(value){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column. Operator: greaterThan{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isin-QBPart}{tr:id=name}{td}h6.isin{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}isin{span}{span}\(query){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with subquery result.{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[QBPart]} query -- subquery {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isin-ObjectArray}{tr:id=name}{td}h6.isin{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}isin{span}{span}\(values){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with values.{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]\[]} values -- array of values {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=le-Object}{tr:id=name}{td}h6.le{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}le{span}{span}\(value){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column. Operator: lessThanOrEqual{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

))

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=like-String}{tr:id=name}{td}h6.like{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}like{span}{span}\(pattern){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column. Operator: like{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[String]} pattern -- the string value of the pattern {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	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%'))

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	like-String_String

}{

Table Row (tr)

:

id

=

	name

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

Table Cell (td)
like

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBCondition

]{span}{span:style=

Span

style	font-weight:

bold;

}

like

{span}{span}\

Span
(pattern,

escape)

{span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column. Operator: like, with escape character{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[String]} pattern -- the string value of the pattern \{[String]} escape -- the escape char {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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_%', '_'))

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	locate-Object_Number

}{

Table Row (tr)

:

id

=

	name

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

Table Cell (td)
locate

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}

locate

{span}{span}\

Span
(arg,

start)

{span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create locate(arg,

start)

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

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)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=lt-Object}{tr:id=name}{td}h6.lt{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}lt{span}{span}\(value){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column. Operator: lessThan{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	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)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=multiply-Object}{tr:id=name}{td}h6.multiply{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}multiply{span}{span}\(arg){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Multiply with value{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- nr to multiply with {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	nullif-Object

Table Row (tr)

id	name

Table Cell (td)
nullif

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBFunction

Span

style	font-weight: bold;

nullif

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

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	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)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=substring-Number}{tr:id=name}{td}h6.substring{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}substring{span}{span}\(pos){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create substring(pos) expression{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Number]} pos {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	substring-Number_Number

}{

Table Row (tr)

:

id

=

	name

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

Table Cell (td)
substring

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}[

QBFunction

]{span}{span:style=

Span

style	font-weight:

bold;

}

substring

{span}{span}\

Span
(pos,

len)

{span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create substring(pos,

len)

expression{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Number]} pos \{[Number]} len {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Page History

Versions Compared

Old Version 8

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