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 |
Samplequery.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 |
Samplequery.result.add(query.columns.custname.bit_length) |
ceil |
Create ceil(column) expression
|
Returns |
Samplequery.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 |
Samplequery.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 |
Samplequery.result.add(query.columns.mycol.floor) |
hour |
Extract hour from date
|
Returns |
Samplequery.result.add(query.columns.mydatecol.hour) |
isNull |
Compare column with null.
|
Returns |
Samplequery.where.add(query.columns.flag.isNull) |
len |
Create length(column) expression
|
Returns |
Samplequery.result.add(query.columns.custname.len) |
lower |
Create lower(column) expression
|
Returns |
Samplequery.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 |
Samplequery.result.add(query.columns.mydatecol.minute) |
month |
Extract month from date
|
Returns |
Samplequery.result.add(query.columns.mydatecol.month) |
not |
Create a negated condition.
|
Returns |
Samplequery.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 |
Samplequery.result.add(query.columns.mycol.round) |
second |
Extract second from date
|
Returns |
Samplequery.result.add(query.columns.mydatecol.second) |
sqrt |
Create sqrt(column) expression
|
Returns |
Samplequery.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 |
Samplequery.result.add(query.columns.custname.trim) |
upper |
Create upper(column) expression
|
Returns |
Samplequery.result.add(query.columns.custname.upper) |
year |
Extract year from date
|
Returns |
Samplequery.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 |
Samplequery.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 |
Samplequery.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 |
Samplequery.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 |
Samplequery.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 |
Samplequery.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 |
Samplequery.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 |
Samplequery.where.add(query.columns.flag.gt(0)) |
isin |
QBCondition isin (query) |
Compare column with subquery result.
|
Parameters {QBPart} query – subquery
|
Returns |
Samplequery.where.add(query.columns.flag.isin(query2)) |
isin |
QBCondition isin (values) |
Compare column with values.
|
Parameters {Object[]} values – array of values
|
Returns |
Samplequery.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 |
Samplequery.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 |
Samplequery.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 |
Samplequery.where.add(query.columns.companyname.like('X_%', '_')) |
locate |
QBFunction locate (arg) |
Create locate(arg) expression
|
Parameters {Object} arg – string to locate
|
Returns |
Samplequery.result.add(query.columns.mycol.locate('sample')) |
locate |
QBFunction locate (arg, start) |
Create locate(arg, start) expression
|
Parameters |
Returns |
Samplequery.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 |
Samplequery.where.add(query.columns.flag.lt(99)) |
minus |
QBFunction minus (arg) |
Subtract value
|
Parameters {Object} arg – nr to subtract
|
Returns |
Samplequery.result.add(query.columns.mycol.minus(2)) |
mod |
QBFunction mod (arg) |
Create mod(arg) expression
|
Parameters {Object} arg – mod arg
|
Returns |
Samplequery.result.add(query.columns.mycol.mod(2)) |
multiply |
QBFunction multiply (arg) |
Multiply with value
|
Parameters {Object} arg – nr to multiply with
|
Returns |
Samplequery.result.add(query.columns.mycol.multiply(2)) |
nullif |
QBFunction nullif (arg) |
Create nullif(arg) expression
|
Parameters {Object} arg – object to compare
|
Returns |
Samplequery.result.add(query.columns.mycol.nullif('none')) |
plus |
QBFunction plus (arg) |
Add up value
|
Parameters {Object} arg – nr to add
|
Returns |
Samplequery.result.add(query.columns.mycol.plus(2)) |
substring |
QBFunction substring (pos) |
Create substring(pos) expression
|
Parameters {Number} pos
|
Returns |
Samplequery.result.add(query.columns.mycol.substring(3)) |
substring |
QBFunction substring (pos, len) |
Create substring(pos, len) expression
|
Parameters |
Returns |
Samplequery.result.add(query.columns.mycol.substring(3, 2)) |