Create abs(column) expression |
|
Create an ascending sort expression |
|
Create an aggregate expression. |
|
Create bit_length(column) expression |
|
Create ceil(column) expression |
|
Create an aggregate expression. |
|
Create an descending sort expression |
|
Create floor(column) expression |
|
Compare column with null. |
|
Create length(column) expression |
|
Create lower(column) expression |
|
Create an aggregate expression. |
|
Create an aggregate expression. |
|
Create a negated condition. |
|
Get query builder parent table clause, this may be a query or a join clause. |
|
Get query builder parent. |
|
Create round(column) expression |
|
Create sqrt(column) expression |
|
Create an aggregate expression. |
|
Create trim(column) expression |
|
Create upper(column) expression |
|
|
Compare column to a range of 2 values or other columns. |
|
Create cast(column, type) expression |
|
Compare column with a value or another column. |
|
Compare column with a value or another column. |
|
The flags are a bit pattern consisting of 1 or more of the following bits:
- JSColumn. |
|
Compare column with a value or another column. |
|
Compare column with subquery result. |
|
Compare column with values. |
|
Compare column with custom query result. |
|
Compare column with a value or another column. |
|
Compare column with a value or another column. |
|
Compare column with a value or another column. |
|
Create locate(arg) expression |
|
Create locate(arg, start) expression |
|
Compare column with a value or another column. |
|
Create mod(arg) expression |
|
Create nullif(arg) expression |
|
Create substring(pos) expression |
|
Create substring(pos, len) expression |
|
|
Create abs(column) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.custname.abs) |
|
|
|
|
Create an ascending sort expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample 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) |
|
|
|
|
Create an aggregate expression. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample 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) |
|
|
|
|
Create bit_length(column) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.custname.bit_length) |
|
|
|
|
Create ceil(column) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.ceil) |
|
|
|
|
Create an aggregate expression. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample 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) |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mydatecol.day) |
|
|
|
|
Create an descending sort expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample 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) |
|
|
|
|
Create floor(column) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.floor) |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mydatecol.hour) |
|
|
|
|
Compare column with null. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.flag.isNull) |
|
|
|
|
Create length(column) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.custname.len) |
|
|
|
|
Create lower(column) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.custname.lower) |
|
|
|
|
Create an aggregate expression. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample 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) |
|
|
|
|
Create an aggregate expression. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample 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) |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mydatecol.minute) |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mydatecol.month) |
|
|
|
|
Create a negated condition. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.flag.not.eq(1)) |
|
|
|
|
Get query builder parent table clause, this may be a query or a join clause. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample 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) |
|
|
|
|
Get query builder parent. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample 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) |
|
|
|
|
Create round(column) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.round) |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mydatecol.second) |
|
|
|
|
Create sqrt(column) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.custname.sqrt) |
|
|
|
|
Create an aggregate expression. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample 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) |
|
|
|
|
Create trim(column) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.custname.trim) |
|
|
|
|
Create upper(column) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.custname.upper) |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mydatecol.year) |
|
|
|
|
|
Compare column to a range of 2 values or other columns. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.flag.between(0, 5)) |
|
|
|
|
Create cast(column, type) expression |
|
|
Parameters string type, see QUERY_COLUMN_TYPES |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.cast(QUERY_COLUMN_TYPES.TYPE_INTEGER)) |
|
|
|
|
Parameters valeu to concatenate with |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.firstname.concat(' ').concat(query.columns.lastname)) |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.divide(2)) |
|
|
|
|
Compare column with a value or another column.
Operator: equals |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.flag.eq(1)) |
|
|
|
|
Compare column with a value or another column.
Operator: greaterThanOrEqual |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.flag.ge(2)) |
|
|
|
|
The flags are a bit pattern consisting of 1 or more of the following bits:
- JSColumn.UUID_COLUMN
- JSColumn.EXCLUDED_COLUMN
- JSColumn.TENANT_COLUMN |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
|
Compare column with a value or another column.
Operator: greaterThan |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.flag.gt(0)) |
|
|
|
|
Compare column with subquery result. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.flag.isin(query2)) |
|
|
|
|
Compare column with values. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.flag.isin([1, 5, 99])) |
|
|
|
|
Compare column with custom query result. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.ccy.isin("select ccycode from currencies c where c.category = " + query.getTableAlias() + ".currency_category and c.flag = ?", ['T'])) |
|
|
|
|
Compare column with a value or another column.
Operator: lessThanOrEqual |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.flag.le(2)) |
|
|
|
|
Compare column with a value or another column.
Operator: like |
|
|
Parameters the string value of the pattern |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.companyname.like('Serv%')) |
|
|
|
|
Compare column with a value or another column.
Operator: like, with escape character |
|
|
Parameters the string value of the pattern |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.companyname.like('X_%', '_')) |
|
|
|
|
Create locate(arg) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.locate('sample')) |
|
|
|
|
Create locate(arg, start) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.locate('sample', 5)) |
|
|
|
|
Compare column with a value or another column.
Operator: lessThan |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.where.add(query.columns.flag.lt(99)) |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.minus(2)) |
|
|
|
|
Create mod(arg) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.mod(2)) |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.multiply(2)) |
|
|
|
|
Create nullif(arg) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.nullif('none')) |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.plus(2)) |
|
|
|
|
Create substring(pos) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.substring(3)) |
|
|
|
|
Create substring(pos, len) expression |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample query.result.add(query.columns.mycol.substring(3, 2)) |
|
|
|
|
|
|