Child pages
  • QBFunction
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Unknown macro: {div}

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

Unknown macro: {div}


Unknown macro: {table}

{column:width=80px|padding=0px}{column}{column}{column}

Unknown macro: {tr}
Unknown macro: {th}

Property Summary

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

abs
Create abs(column) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBSort

Unknown macro: {td}

asc
Create an ascending sort expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBAggregate

Unknown macro: {td}

avg
Create an aggregate expression.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

bit_length
Create bit_length(column) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

ceil
Create ceil(column) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBAggregate

Unknown macro: {td}

count
Create an aggregate expression.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

day
Extract day from date

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBSort

Unknown macro: {td}

desc
Create an descending sort expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

floor
Create floor(column) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

hour
Extract hour from date

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBCondition

Unknown macro: {td}

isNull
Compare column with null.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

len
Create length(column) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

lower
Create lower(column) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBAggregate

Unknown macro: {td}

max
Create an aggregate expression.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBAggregate

Unknown macro: {td}

min
Create an aggregate expression.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

minute
Extract minute from date

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

month
Extract month from date

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBColumn

Unknown macro: {td}

not
Create a negated condition.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBTableClause

Unknown macro: {td}

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

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBSelect

Unknown macro: {td}

root
Get query builder parent.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

round
Create round(column) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

second
Extract second from date

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

sqrt
Create sqrt(column) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBAggregate

Unknown macro: {td}

sum
Create an aggregate expression.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

trim
Create trim(column) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

upper
Create upper(column) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

year
Extract year from date


Unknown macro: {table}

{column:width=80px|padding=0px}{column}{column}{column}

Unknown macro: {tr}
Unknown macro: {th}

Method Summary

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBCondition

Unknown macro: {td}

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

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

cast(type)
Create cast(column, type) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

concat(arg)
Concatename with value

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

divide(arg)
Divide by value

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBCondition

Unknown macro: {td}

eq(value)
Compare column with a value or another column.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBCondition

Unknown macro: {td}

ge(value)
Compare column with a value or another column.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBCondition

Unknown macro: {td}

gt(value)
Compare column with a value or another column.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBCondition

Unknown macro: {td}

isin(query)
Compare column with subquery result.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBCondition

Unknown macro: {td}

isin(values)
Compare column with values.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBCondition

Unknown macro: {td}

le(value)
Compare column with a value or another column.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBCondition

Unknown macro: {td}

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

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBCondition

Unknown macro: {td}

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

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

locate(arg)
Create locate(arg) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

locate(arg, start)
Create locate(arg, start) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBCondition

Unknown macro: {td}

lt(value)
Compare column with a value or another column.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

minus(arg)
Subtract value

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

mod(arg)
Create mod(arg) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

multiply(arg)
Multiply with value

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

nullif(arg)
Create nullif(arg) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

plus(arg)
Add up value

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

substring(pos)
Create substring(pos) expression

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBFunction

Unknown macro: {td}

substring(pos, len)
Create substring(pos, len) expression


Unknown macro: {table}

{column:width=100%|padding=0px}{column}

Unknown macro: {tr}
Unknown macro: {th}

Property Details

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
abs
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.custname.abs)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
asc
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBSort

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
/** @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)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
avg
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBAggregate

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
/** @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)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
bit_length
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.custname.bit_length)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
ceil
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.ceil)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
count
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBAggregate

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
/** @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)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
day
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mydatecol.day)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
desc
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBSort

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
/** @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)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
floor
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.floor)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
hour
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mydatecol.hour)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
isNull
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBCondition

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.where.add(query.columns.flag.isNull)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
len
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.custname.len)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
lower
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.custname.lower)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
max
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBAggregate

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
/** @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)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
min
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBAggregate

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
/** @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)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
minute
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mydatecol.minute)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
month
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mydatecol.month)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
not
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBColumn

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.where.add(query.columns.flag.not.eq(1))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
parent
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBTableClause

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
/** @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)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
root
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBSelect

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
/** @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)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
round
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.round)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
second
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mydatecol.second)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
sqrt
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.custname.sqrt)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
sum
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBAggregate

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
/** @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)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
trim
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.custname.trim)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
upper
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.custname.upper)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
year
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mydatecol.year)
Unknown macro: {tr}
Unknown macro: {td}


Unknown macro: {table}

{column:width=100%|padding=0px}{column}

Unknown macro: {tr}
Unknown macro: {th}

Method Details

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
between
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBCondition

Unknown macro: {span}

between

Unknown macro: {span}

(value1, value2)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} value1
{Object} value2

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBCondition

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.where.add(query.columns.flag.between(0, 5))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
cast
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBFunction

Unknown macro: {span}

cast

Unknown macro: {span}

(type)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{String} type – string type, see QUERY_COLUMN_TYPES

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.cast(QUERY_COLUMN_TYPES.TYPE_INTEGER))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
concat
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBFunction

Unknown macro: {span}

concat

Unknown macro: {span}

(arg)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} arg – valeu to concatenate with

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.firstname.concat(' ').concat(query.columns.lastname))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
divide
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBFunction

Unknown macro: {span}

divide

Unknown macro: {span}

(arg)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} arg – nr to divide by

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.divide(2))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
eq
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBCondition

Unknown macro: {span}

eq

Unknown macro: {span}

(value)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} value

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBCondition

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.where.add(query.columns.flag.eq(1))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
ge
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBCondition

Unknown macro: {span}

ge

Unknown macro: {span}

(value)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} value

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBCondition

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.where.add(query.columns.flag.ge(2))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
gt
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBCondition

Unknown macro: {span}

gt

Unknown macro: {span}

(value)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} value

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBCondition

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.where.add(query.columns.flag.gt(0))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
isin
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBCondition

Unknown macro: {span}

isin

Unknown macro: {span}

(query)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{QBPart} query – subquery

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBCondition

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.where.add(query.columns.flag.isin(query2))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
isin
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBCondition

Unknown macro: {span}

isin

Unknown macro: {span}

(values)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object[]} values – array of values

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBCondition

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.where.add(query.columns.flag.isin([1, 5, 99]))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
le
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBCondition

Unknown macro: {span}

le

Unknown macro: {span}

(value)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} value

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBCondition

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.where.add(query.columns.flag.le(2))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
like
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBCondition

Unknown macro: {span}

like

Unknown macro: {span}

(pattern)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{String} pattern – the string value of the pattern

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBCondition

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.where.add(query.columns.companyname.like('Serv%'))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
like
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBCondition

Unknown macro: {span}

like

Unknown macro: {span}

(pattern, escape)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

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

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBCondition

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.where.add(query.columns.companyname.like('X_%', '_'))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
locate
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBFunction

Unknown macro: {span}

locate

Unknown macro: {span}

(arg)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} arg – string to locate

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.locate('sample'))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
locate
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBFunction

Unknown macro: {span}

locate

Unknown macro: {span}

(arg, start)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} arg – string to locate
{Number} start – start pos

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.locate('sample', 5))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
lt
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBCondition

Unknown macro: {span}

lt

Unknown macro: {span}

(value)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} value

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBCondition

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.where.add(query.columns.flag.lt(99))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
minus
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBFunction

Unknown macro: {span}

minus

Unknown macro: {span}

(arg)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} arg – nr to subtract

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.minus(2))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
mod
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBFunction

Unknown macro: {span}

mod

Unknown macro: {span}

(arg)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} arg – mod arg

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.mod(2))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
multiply
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBFunction

Unknown macro: {span}

multiply

Unknown macro: {span}

(arg)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} arg – nr to multiply with

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.multiply(2))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
nullif
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBFunction

Unknown macro: {span}

nullif

Unknown macro: {span}

(arg)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} arg – object to compare

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.nullif('none'))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
plus
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBFunction

Unknown macro: {span}

plus

Unknown macro: {span}

(arg)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} arg – nr to add

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.plus(2))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
substring
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBFunction

Unknown macro: {span}

substring

Unknown macro: {span}

(pos)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Number} pos

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.substring(3))
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
substring
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBFunction

Unknown macro: {span}

substring

Unknown macro: {span}

(pos, len)

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{Number} pos
{Number} len

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBFunction

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.result.add(query.columns.mycol.substring(3, 2))
Unknown macro: {tr}
Unknown macro: {td}
  • No labels