QBLogicalCondition

Property Summary

Type	Name	Summary
Array	conditionnames	Get the names for the conditions in the logical condition..
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

Type	Name	Summary
QBLogicalCondition	add(condition)	Add a condition to the AND or OR condition list..
QBLogicalCondition	add(name, condition)	Add a named condition to the logical condition..
QBLogicalCondition	clear()	Clear the conditions in the logical condition..
QBLogicalCondition	getCondition(name)	Get a named condition in the logical condition..
QBLogicalCondition	remove(name)	Remove a named condition from the logical condition..

Properties Details

conditionnames

Get the names for the conditions in the logical condition.

Returns Array

Sample

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.

Returns QBTableClause

Sample

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.

Returns QBSelect

Sample

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.

Parameters QBCondition condition the condition to add

Returns QBLogicalCondition

Sample

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 QBCondition condition the condition to add

Returns QBLogicalCondition

Sample

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

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

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

var cond = query.getCondition('mycond')
cond.remove('mysubcond')