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

Enter additional information related to this 'class' inside the {div} macro with 'id=description'

Unknown macro: {div}


Unknown macro: {table}
Unknown macro: {colgroup}
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}
Unknown macro: {colgroup}
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}
Unknown macro: {colgroup}
Unknown macro: {tr}
Unknown macro: {th}

Property Details

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

Create abs(column) expression

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}
Unknown macro: {div}

Create an ascending sort expression

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}
Unknown macro: {div}

Create an aggregate expression.

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}
Unknown macro: {div}

Create bit_length(column) expression

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}
Unknown macro: {div}

Create ceil(column) expression

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}
Unknown macro: {div}

Create an aggregate expression.

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}
Unknown macro: {div}

Extract day from date

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}
Unknown macro: {div}

Create an descending sort expression

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}
Unknown macro: {div}

Create floor(column) expression

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}
Unknown macro: {div}

Extract hour from date

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}
Unknown macro: {div}

Compare column with null.

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}
Unknown macro: {div}

Create length(column) expression

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}
Unknown macro: {div}

Create lower(column) expression

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}
Unknown macro: {div}

Create an aggregate expression.

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}
Unknown macro: {div}

Create an aggregate expression.

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}
Unknown macro: {div}

Extract minute from date

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}
Unknown macro: {div}

Extract month from date

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}
Unknown macro: {div}

Create a negated condition.

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}
Unknown macro: {div}

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

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}
Unknown macro: {div}

Get query builder parent.

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}
Unknown macro: {div}

Create round(column) expression

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}
Unknown macro: {div}

Extract second from date

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}
Unknown macro: {div}

Create sqrt(column) expression

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}
Unknown macro: {div}

Create an aggregate expression.

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}
Unknown macro: {div}

Create trim(column) expression

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}
Unknown macro: {div}

Create upper(column) expression

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}
Unknown macro: {div}

Extract year from date

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}
Unknown macro: {colgroup}
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}
Unknown macro: {div}

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

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}
Unknown macro: {div}

Create cast(column, type) expression

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}
Unknown macro: {div}

Concatename with value

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}
Unknown macro: {div}

Divide by value

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}
Unknown macro: {div}

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

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}
Unknown macro: {div}

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

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}
Unknown macro: {div}

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

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}
Unknown macro: {div}

Compare column with subquery result.

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}
Unknown macro: {div}

Compare column with 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}
Unknown macro: {div}

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

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}
Unknown macro: {div}

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

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}
Unknown macro: {div}

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

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}
Unknown macro: {div}

Create locate(arg) expression

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}
Unknown macro: {div}

Create locate(arg, start) expression

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}
Unknown macro: {div}

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

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}
Unknown macro: {div}

Subtract value

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}
Unknown macro: {div}

Create mod(arg) expression

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}
Unknown macro: {div}

Multiply with value

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}
Unknown macro: {div}

Create nullif(arg) expression

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}
Unknown macro: {div}

Add up value

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}
Unknown macro: {div}

Create substring(pos) expression

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}
Unknown macro: {div}

Create substring(pos, len) expression

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