May 03, 2024 00:55 Returns Supported Clients Sample Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients SampleSupported Clients
SmartClient
WebClient
NGClient
Property Summary
QBSelect
parent
Get query builder parent table clause, this may be a query or a join clause.
QBSelect
root
Get query builder parent.
Methods Summary
QBSorts
add(columnSortAsc)
Ad an ascending sorting on a column to the query sort.
QBSorts
add(functionSortAsc)
Ad an ascending sorting on a column to the query sort.
QBSorts
add(sort)
Ad a sorting on a column to the query sort.
QBSorts
addPk()
Add the tables' primary pk columns in alphabetical order to the query sort.
QBSorts
clear()
Clear the sorting clause for the query.
Property Details
parent
Get query builder parent table clause, this may be a query or a join clause.
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
Get query builder parent.
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)
Methods Details
add(columnSortAsc)
Ad an ascending sorting on a column to the query sort.
QBColumn
columnSortAsc
column to sort by
query.sort.add(query.columns.orderid)
add(functionSortAsc)
Ad an ascending sorting on a column to the query sort.
QBFunction
functionSortAsc
function to add
query.sort.add(query.columns.orderid)
add(sort)
Ad a sorting on a column to the query sort.
QBSort
sort
the sort to add
query.sort.add(query.columns.orderid.desc)
addPk()
Add the tables' primary pk columns in alphabetical order to the query sort.
query.sort.addPk()
clear()
Clear the sorting clause for the query.
query.sort.clear()