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 Sample
May 02, 2024 18:23Supported 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.
SmartClient,WebClient,NGClient
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.
SmartClient,WebClient,NGClient
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
SmartClient,WebClient,NGClient
query.sort.add(query.columns.orderid)
add(functionSortAsc)
Ad an ascending sorting on a column to the query sort.
QBFunction
functionSortAsc
function to add
SmartClient,WebClient,NGClient
query.sort.add(query.columns.orderid)
add(sort)
Ad a sorting on a column to the query sort.
QBSort
sort
the sort to add
SmartClient,WebClient,NGClient
query.sort.add(query.columns.orderid.desc)
addPk()
Add the tables' primary pk columns in alphabetical order to the query sort.
SmartClient,WebClient,NGClient
query.sort.addPk()
clear()
Clear the sorting clause for the query.
SmartClient,WebClient,NGClient
query.sort.clear()
Overview
Content Tools
Activity