May 21, 2024 11:50 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 SampleSupported 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.
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.
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(condition)
Add a condition to the AND or OR condition list.
QBCondition
condition
the condition to add
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
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.
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.
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.
var query = datasources.db.example_data.orders.createSelect();
query.where.remove("mycond")