Apr 23, 2024 18:14 Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients SampleSupported Clients
SmartClient
WebClient
NGClient
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
Methods 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
isin(customQuery, args)
Compare column with custom query result.
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
query.result.add(query.columns.custname.abs)
asc
var query = datasources.db.example_data.orders.createSelect();
query.sort
.add(query.joins.orders_to_order_details.columns.quantity.asc)
.add(query.columns.companyid)
foundset.loadRecords(query)
avg
var query = datasources.db.example_data.orders.createSelect();
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
query.result.add(query.columns.custname.bit_length)
ceil
query.result.add(query.columns.mycol.ceil)
count
var query = datasources.db.example_data.orders.createSelect();
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
query.result.add(query.columns.mydatecol.day)
desc
var query = datasources.db.example_data.orders.createSelect();
query.sort
.add(query.joins.orders_to_order_details.columns.quantity.desc)
.add(query.columns.companyid)
foundset.loadRecords(query)
floor
query.result.add(query.columns.mycol.floor)
hour
query.result.add(query.columns.mydatecol.hour)
isNull
query.where.add(query.columns.flag.isNull)
len
query.result.add(query.columns.custname.len)
lower
query.result.add(query.columns.custname.lower)
max
var query = datasources.db.example_data.orders.createSelect();
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
var query = datasources.db.example_data.orders.createSelect();
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
query.result.add(query.columns.mydatecol.minute)
month
query.result.add(query.columns.mydatecol.month)
not
query.where.add(query.columns.flag.not.eq(1))
parent
var query = datasources.db.example_data.person.createSelect();
query.where.add(query.joins.person_to_parent.joins.person_to_parent.columns.name.eq('john'))
foundset.loadRecords(query)
root
var subquery = datasources.db.example_data.order_details.createSelect();
var query = datasources.db.example_data.orders.createSelect();
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
query.result.add(query.columns.mycol.round)
second
query.result.add(query.columns.mydatecol.second)
sqrt
query.result.add(query.columns.custname.sqrt)
sum
var query = datasources.db.example_data.orders.createSelect();
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
query.result.add(query.columns.custname.trim)
upper
query.result.add(query.columns.custname.upper)
year
query.result.add(query.columns.mydatecol.year)
Methods Details
between(value1, value2)
Object
value1
Object
value2
query.where.add(query.columns.flag.between(0, 5))
cast(type)
String
type
string type, see QUERY_COLUMN_TYPES
query.result.add(query.columns.mycol.cast(QUERY_COLUMN_TYPES.TYPE_INTEGER))
concat(arg)
Object
arg
valeu to concatenate with
query.result.add(query.columns.firstname.concat(' ').concat(query.columns.lastname))
divide(arg)
Object
arg
nr to divide by
query.result.add(query.columns.mycol.divide(2))
eq(value)
Object
value
query.where.add(query.columns.flag.eq(1))
ge(value)
Object
value
query.where.add(query.columns.flag.ge(2))
gt(value)
Object
value
query.where.add(query.columns.flag.gt(0))
isin(query)
QBPart
query
subquery
query.where.add(query.columns.flag.isin(query2))
isin(values)
Array
values
array of values
query.where.add(query.columns.flag.isin([1, 5, 99]))
isin(customQuery, args)
String
customQuery
custom query
Array
args
query arguments
query.where.add(query.columns.ccy.isin("select ccycode from currencies c where c.category = " + query.getTableAlias() + ".currency_category and c.flag = ?", ['T']))
le(value)
Object
value
query.where.add(query.columns.flag.le(2))
like(pattern)
String
pattern
the string value of the pattern
query.where.add(query.columns.companyname.like('Serv%'))
like(pattern, escape)
String
pattern
the string value of the pattern
Number
escape
the escape char
query.where.add(query.columns.companyname.like('X_%', '_'))
locate(arg)
Object
arg
string to locate
query.result.add(query.columns.mycol.locate('sample'))
locate(arg, start)
Object
arg
string to locate
Number
start
start pos
query.result.add(query.columns.mycol.locate('sample', 5))
lt(value)
Object
value
query.where.add(query.columns.flag.lt(99))
minus(arg)
Object
arg
nr to subtract
query.result.add(query.columns.mycol.minus(2))
mod(arg)
Object
arg
mod arg
query.result.add(query.columns.mycol.mod(2))
multiply(arg)
Object
arg
nr to multiply with
query.result.add(query.columns.mycol.multiply(2))
nullif(arg)
Object
arg
object to compare
query.result.add(query.columns.mycol.nullif('none'))
plus(arg)
Object
arg
nr to add
query.result.add(query.columns.mycol.plus(2))
substring(pos)
Number
pos
query.result.add(query.columns.mycol.substring(3))
substring(pos, len)
Number
pos
Number
len
query.result.add(query.columns.mycol.substring(3, 2))