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 2
Next »
Unknown macro: {sub-section}
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} abs
Create abs(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} asc
Create an ascending sort expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} avg
Create an aggregate expression.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} bit_length
Create bit_length(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} ceil
Create ceil(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} count
Create an aggregate expression.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} day
Extract day from date
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} desc
Create an descending sort expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} floor
Create floor(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} hour
Extract hour from date
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} isNull
Compare column with null.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} len
Create length(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} lower
Create lower(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} max
Create an aggregate expression.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} min
Create an aggregate expression.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} minute
Extract minute from date
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} month
Extract month from date
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} not
Create a negated condition.
Unknown macro: {tbody} Unknown macro: {tr} 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} root
Get query builder parent.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} round
Create round(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} second
Extract second from date
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} sqrt
Create sqrt(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} sum
Create an aggregate expression.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} trim
Create trim(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} upper
Create upper(column) expression
Unknown macro: {tbody} Unknown macro: {tr} 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} between(value1, value2)
Compare column to a range of 2 values or other columns.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} cast(type)
Create cast(column, type) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} concat(arg)
Concatename with value
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} divide(arg)
Divide by value
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} eq(value)
Compare column with a value or another column.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} ge(value)
Compare column with a value or another column.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} gt(value)
Compare column with a value or another column.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} isin(query)
Compare column with subquery result.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} isin(values)
Compare column with values.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} le(value)
Compare column with a value or another column.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} like(pattern)
Compare column with a value or another column.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} like(pattern, escape)
Compare column with a value or another column.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} locate(arg)
Create locate(arg) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} locate(arg, start)
Create locate(arg, start) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} lt(value)
Compare column with a value or another column.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} minus(arg)
Subtract value
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} mod(arg)
Create mod(arg) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} multiply(arg)
Multiply with value
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} nullif(arg)
Create nullif(arg) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} plus(arg)
Add up value
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} substring(pos)
Create substring(pos) expression
Unknown macro: {tbody} Unknown macro: {tr} 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} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create abs(column) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.custname.abs)
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create an ascending sort expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {sub-section} QBSort
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
/** @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} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create an aggregate expression.
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
/** @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: {sub-section}
Unknown macro: {sub-section} Create bit_length(column) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.custname.bit_length)
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create ceil(column) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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: {sub-section}
Unknown macro: {sub-section} Create an aggregate expression.
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
/** @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} Unknown macro: {sub-section}
Unknown macro: {sub-section} Extract day from date
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.mydatecol.day)
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create an descending sort expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {sub-section} QBSort
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
/** @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: {sub-section}
Unknown macro: {sub-section} Create floor(column) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.mycol.floor)
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Extract hour from date
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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: {sub-section}
Unknown macro: {sub-section} Compare column with null.
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.where.add(query.columns.flag.isNull)
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create length(column) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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: {sub-section}
Unknown macro: {sub-section} Create lower(column) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.custname.lower)
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create an aggregate expression.
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
/** @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} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create an aggregate expression.
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
/** @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: {sub-section}
Unknown macro: {sub-section} Extract minute from date
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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: {sub-section}
Unknown macro: {sub-section} Extract month from date
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.mydatecol.month)
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create a negated condition.
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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: {sub-section}
Unknown macro: {sub-section} Get query builder parent table clause, this may be a query or a join clause.
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
/** @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} Unknown macro: {sub-section}
Unknown macro: {sub-section} Get query builder parent.
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
/** @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: {sub-section}
Unknown macro: {sub-section} Create round(column) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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: {sub-section}
Unknown macro: {sub-section} Extract second from date
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.mydatecol.second)
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create sqrt(column) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.custname.sqrt)
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create an aggregate expression.
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
/** @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} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create trim(column) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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: {sub-section}
Unknown macro: {sub-section} Create upper(column) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.custname.upper)
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Extract year from date
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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} between
Unknown macro: {span} (value1, value2)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Compare column to a range of 2 values or other columns.
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} value1
{Object} value2
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.where.add(query.columns.flag.between(0, 5))
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} cast
Unknown macro: {span} (type)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create cast(column, type) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {String} type – string type, see QUERY_COLUMN_TYPES
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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} concat
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Concatename with value
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} arg – valeu to concatenate with
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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} divide
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Divide by value
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} arg – nr to divide by
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.mycol.divide(2))
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} (value)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Compare column with a value or another column.
Operator: equals
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} value
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.where.add(query.columns.flag.eq(1))
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} (value)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Compare column with a value or another column.
Operator: greaterThanOrEqual
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} value
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.where.add(query.columns.flag.ge(2))
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} (value)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Compare column with a value or another column.
Operator: greaterThan
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} value
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.where.add(query.columns.flag.gt(0))
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} isin
Unknown macro: {span} (query)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Compare column with subquery result.
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {QBPart} query – subquery
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.where.add(query.columns.flag.isin(query2))
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} isin
Unknown macro: {span} (values)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Compare column with values.
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object[]} values – array of values
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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} Unknown macro: {span} (value)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Compare column with a value or another column.
Operator: lessThanOrEqual
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} value
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.where.add(query.columns.flag.le(2))
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} like
Unknown macro: {span} (pattern)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Compare column with a value or another column.
Operator: like
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {String} pattern – the string value of the pattern
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.where.add(query.columns.companyname.like('Serv%'))
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} like
Unknown macro: {span} (pattern, escape)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Compare column with a value or another column.
Operator: like, with escape character
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {String} pattern – the string value of the pattern
{String} escape – the escape char
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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} locate
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create locate(arg) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} arg – string to locate
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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} locate
Unknown macro: {span} (arg, start)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create locate(arg, start) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} arg – string to locate
{Number} start – start pos
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.mycol.locate('sample', 5))
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} (value)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Compare column with a value or another column.
Operator: lessThan
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} value
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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} minus
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Subtract value
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} arg – nr to subtract
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.mycol.minus(2))
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} mod
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create mod(arg) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} arg – mod arg
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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} multiply
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Multiply with value
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} arg – nr to multiply with
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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} nullif
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create nullif(arg) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} arg – object to compare
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.mycol.nullif('none'))
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} plus
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Add up value
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Object} arg – nr to add
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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} substring
Unknown macro: {span} (pos)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create substring(pos) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section} {Number} pos
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
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} substring
Unknown macro: {span} (pos, len)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {sub-section}
Unknown macro: {sub-section} Create substring(pos, len) expression
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Since
Unknown macro: {sub-section}
Unknown macro: {sub-section} Replace with version info
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} Also see
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {builder-show} Unknown macro: {tr} Unknown macro: {td} External links
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {sub-section}
Unknown macro: {div} Unknown macro: {sub-section}
query.result.add(query.columns.mycol.substring(3, 2))
Unknown macro: {tr} Unknown macro: {td}