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 8
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}
{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} 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: {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} abs(value)
Create abs(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} bit_length(value)
Create bit_length(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} cast(value, type)
Cast using type name.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} ceil(arg)
Create ceil(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} coalesce(args)
Create year(date) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} concat(arg1, arg2)
Create concat(args, arg2) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} day(arg)
Create day(date) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} divide(arg1, arg2)
Create divide(args, arg2) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} floor(arg)
Create floor(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} hour(arg)
Create hour(date) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} len(value)
Create length(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} locate(string1, string2)
Create locate(str1, str2) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} locate(string1, string2, start)
Create locate(str1, str2, start) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} lower(value)
Create lower(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} minus(arg1, arg2)
Create minus(args, arg2) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} minute(arg)
Create minute(date) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} mod(dividend, divisor)
Create mod(dividend, divisor) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} month(arg)
Create month(date) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} multiply(arg1, arg2)
Create multiply(args, arg2) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} nullif(arg1)
Create nullif(arg1, arg2) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} plus(arg1, arg2)
Create plus(args, arg2) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} round(arg)
Create round(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} second(arg)
Create second(date) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} sqrt(value)
Create sqrt(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} substring(arg, pos)
Create substring(column, pos) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} substring(arg, pos, len)
Create substring(column, pos, len) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} trim(value)
Create trim(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} upper(value)
Create upper(column) expression
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} year(arg)
Create year(date) 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} 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: {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} Unknown macro: {div} Get query builder parent.
Unknown macro: {tr} Unknown macro: {td} Returns
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: {table}
{column:width=100%|padding=0px}{column}
Unknown macro: {tr} Unknown macro: {th} Method Details
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} abs
Unknown macro: {span} (value)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create abs(column) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} value
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynum.abs.eq(query.functions.abs(myval)))
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: {span} bit_length
Unknown macro: {span} (value)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create bit_length(column) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} value
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.bit_length.eq(query.functions.bit_length('Sample')))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} cast
Unknown macro: {span} (value, type)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Cast using type name.
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} value – object to cast
{String} type – type see QUERY_COLUMN_TYPES
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} ceil
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create ceil(column) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} arg – number object
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.ceil.eq(query.functions.ceil(myvar))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} coalesce
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} coalesce
Unknown macro: {span} (args)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create year(date) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object...} args – arguments to coalesce
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mycol.coalesce('defval').eq(query.functions.coalesce(myvar, 'defval'))
foundset.loadRecords(query);
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} (arg1, arg2)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create concat(args, arg2) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/udm/contacts>} */
var query = databaseManager.createSelect('db:/udm/contacts') //$NON-NLS-1$
query.result.add(query.columns.name_first.concat(' ').concat(query.columns.name_last))
var ds = databaseManager.getDataSetByQuery(query, -1)
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} day
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create day(date) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} arg – date object
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.day.eq(query.functions.day(mydatevar))
foundset.loadRecords(query);
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} (arg1, arg2)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create divide(args, arg2) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.divide(2).eq(query.functions.divide(myvar, 2))
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: {span} floor
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create floor(column) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} arg – number object
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.floor.eq(query.functions.floor(myvar))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} hour
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create hour(date) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} arg – date object
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.hour.eq(query.functions.hour(mydatevar))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} len
Unknown macro: {span} (value)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create length(column) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} value
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.len.eq(query.functions.len('Sample')))
foundset.loadRecords(query);
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} (string1, string2)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create locate(str1, str2) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} string1 – string to locate
{Object} string2 – string to search in
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.locate('amp').eq(query.functions.locate('Sample', 'amp')))
foundset.loadRecords(query);
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} (string1, string2, start)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create locate(str1, str2, start) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} string1 – string to locate
{Object} string2 – string to search in
{Number} start – start pos
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.locate('amp', 1).eq(query.functions.locate('Sample', 'amp', 1)))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} lower
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} lower
Unknown macro: {span} (value)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create lower(column) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} value
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.lower.eq(query.functions.lower('Sample')))
foundset.loadRecords(query);
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} (arg1, arg2)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create minus(args, arg2) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.minus(2).eq(query.functions.minus(myvar, 2))
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: {span} minute
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create minute(date) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} arg – date object
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.minute.eq(query.functions.minute(mydatevar))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} mod
Unknown macro: {span} (dividend, divisor)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create mod(dividend, divisor) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.mod(2).eq(query.functions.mod(myvar, 2))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} month
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} month
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create month(date) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} arg – date object
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.month.eq(query.functions.month(mydatevar))
foundset.loadRecords(query);
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} (arg1, arg2)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create multiply(args, arg2) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.multiply(2).eq(query.functions.multiply(myvar, 2))
foundset.loadRecords(query);
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} (arg1)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create nullif(arg1, arg2) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} arg1
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.nullif('none').eq(query.functions.nullif('Sample', 'none')))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} plus
Unknown macro: {span} (arg1, arg2)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create plus(args, arg2) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.plus(2).eq(query.functions.plus(myvar, 2))
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: {span} round
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create round(column) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} arg – number object
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.round.eq(query.functions.round(myvar))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} second
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} second
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create second(date) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} arg – date object
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.second.eq(query.functions.second(mydatevar))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} sqrt
Unknown macro: {span} (value)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create sqrt(column) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} value
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynum.sqrt.eq(query.functions.sqrt(myval)))
foundset.loadRecords(query);
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} (arg, pos)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create substring(column, pos) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} arg – column name
{Number} pos – position
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.substring(3).eq(query.functions.substring('Sample', 3)))
foundset.loadRecords(query);
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} (arg, pos, len)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create substring(column, pos, len) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} arg – column name
{Number} pos – position
{Number} len – length
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.substring(3, 2).eq(query.functions.substring('Sample', 3, 2)))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} trim
Unknown macro: {span} (value)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create trim(column) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} value
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.trim.eq(query.functions.trim('Sample')))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} upper
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} upper
Unknown macro: {span} (value)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create upper(column) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} value
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.upper.eq(query.functions.upper('Sample')))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} year
Unknown macro: {span} (arg)
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {div} Create year(date) expression
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {Object} arg – date object
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.year.eq(query.functions.year(mydatevar))
foundset.loadRecords(query);
Unknown macro: {tr} Unknown macro: {td}