May 04, 2024 13:03 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
var q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
var cond = q.where.getCondition(c)
}
parent
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
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)
QBCondition
condition
the condition to add
var query = datasources.db.example_data.orders.createSelect();
query.where.add(query.columns.orderdate.isNull)
add(name, condition)
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()
var query = datasources.db.example_data.orders.createSelect();
query.where.clear()
getCondition(name)
String
name
The condition name.
var q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
var cond = q.where.getCondition(c)
}
remove(name)
String
name
The condition name.
var query = datasources.db.example_data.orders.createSelect();
query.where.remove("mycond")