Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample Returns Supported Clients Sample Parameters Returns Supported Clients Sample Parameters Returns Supported Clients Sample
Apr 18, 2024 20:09Supported Clients
SmartClient
WebClient
NGClient
Property Summary
Array
conditionnames
Get the names for the conditions in the query where-clause.
QBTableClause
parent
Get query builder parent table clause, this may be a query or a join clause.
QBSelect
root
Get query builder parent.
Methods Summary
QBLogicalCondition
add(condition)
Add a condition to the AND or OR condition list.
QBLogicalCondition
add(name, condition)
Add a named condition to the AND or OR condition list.
QBLogicalCondition
clear()
Clear the conditions in the query where-clause.
QBCondition
getCondition(name)
Get a named condition in the query where-clause.
QBLogicalCondition
remove(name)
Remove a named condition from the AND or OR condition list.
Property Details
conditionnames
Get the names for the conditions in the query where-clause.
SmartClient,WebClient,NGClient
var q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
var cond = q.where.getCondition(c)
}
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(condition)
Add a condition to the AND or OR condition list.
QBCondition
condition
the condition to add
SmartClient,WebClient,NGClient
var query = datasources.db.example_data.orders.createSelect();
query.where.add(query.columns.orderdate.isNull)
add(name, condition)
Add a named condition to the AND or OR condition list.
String
name
the name of the condition
QBCondition
condition
the condition to add
SmartClient,WebClient,NGClient
var query = datasources.db.example_data.orders.createSelect();
query.where.add("mycond", query.columns.orderdate.isNull)
clear()
Clear the conditions in the query where-clause.
SmartClient,WebClient,NGClient
var query = datasources.db.example_data.orders.createSelect();
query.where.clear()
getCondition(name)
Get a named condition in the query where-clause.
String
name
The condition name.
SmartClient,WebClient,NGClient
var q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
var cond = q.where.getCondition(c)
}
remove(name)
Remove a named condition from the AND or OR condition list.
String
name
The condition name.
SmartClient,WebClient,NGClient
var query = datasources.db.example_data.orders.createSelect();
query.where.remove("mycond")
Overview
Content Tools
Activity