Overview
Logical clause for a query; conditions can be added by name.
Properties Summarized
Methods Summarized
Properties Detailed
conditionnames
Get the names for the conditions in the logical condition.
Type
Array
Sample
Copy var cond = query .getCondition ( 'mycond' )
for ( var cname in cond .conditionnames)
{
var subcond = cond .getCondition (cname)
}
parent
Get query builder parent table clause, this may be a query or a join clause.
Type
QBTableClause
Sample
Copy 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.
Type
QBSelect
Sample
Copy 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 Detailed
add(condition)
Add a condition to the AND or OR condition list.
Parameters
Returns: QBLogicalCondition
Sample
Copy var query = datasources . db . example_data . orders .createSelect ();
query . where .add ( query . columns . orderdate .isNull)
add(name, condition)
Add a named condition to the logical condition.
Parameters
String name the name of the condition
Returns: QBLogicalCondition
Sample
Copy var query = datasources . db . example_data . orders .createSelect ();
// create a logical condition
var condition = query .and
// add named conditions
condition .add ( "undated" , query . columns . orderdate .isNull)
condition .add ( "expensive" , query . columns . orderamount .gt ( 10000 ))
query . where .add ( "mycond" , condition)
// part of the condition can be removed again
condition .remove ( "undated" )
clear()
Clear the conditions in the logical condition.
Returns: QBLogicalCondition
Sample
Copy var cond = query .getCondition ( 'mycond' )
cond .clear ()
getCondition(name)
Get a named condition in the logical condition.
Parameters
String name The condition name.
Returns: QBLogicalCondition
Sample
Copy var cond = query .getCondition ( 'mycond' )
for ( var cname in cond .conditionnames)
{
var subcond = cond .getCondition (cname)
}
remove(name)
Remove a named condition from the logical condition.
Parameters
String name The condition name.
Returns: QBLogicalCondition
Sample
Copy var cond = query .getCondition ( 'mycond' )
cond .remove ( 'mysubcond' )