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