DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR.

Enter additional information related to this 'class' inside the {div} macro with 'id=description'


Property Summary
String[]
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.

Method Summary
QBWhereCondition
add(condition)
Add a condition to the AND or OR condition list.
QBWhereCondition
add(name, condition)
Add a named condition to the AND or OR condition list.
QBWhereCondition
clear()
Clear the conditions in the query where-clause.
QBCondition
getCondition()
Get a named condition in the query where-clause.
QBWhereCondition
remove()
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.
Returns
String[]
Sample
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.
Returns
QBTableClause
Sample
/** @type {QBSelect<db:/example_data/person>} */
	var query = databaseManager.createSelect('db:/example_data/person')
	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
/** @type {QBSelect<db:/example_data/order_details>} */
	var subquery = databaseManager.createSelect('db:/example_data/order_details')

 /** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	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)

Method Details
add
QBWhereCondition
add
(condition)
Add a condition to the AND or OR condition list.
Parameters
{QBCondition} condition - the condition to add
Returns
QBWhereCondition
Sample
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add(query.columns.orderdate.isNull)

add
QBWhereCondition
add
(name, condition)
Add a named condition to the AND or OR condition list.
Parameters
{String} name - the name of the condition
{QBCondition} condition - the condition to add
Returns
QBWhereCondition
Sample
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add("mycond", query.columns.orderdate.isNull)

clear
QBWhereCondition
clear
()
Clear the conditions in the query where-clause.
Returns
QBWhereCondition
Sample
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.clear()

getCondition
QBCondition
getCondition
()
Get a named condition in the query where-clause.
Returns
QBCondition
Sample
var q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
	var cond = q.where.getCondition(c)
}

remove
QBWhereCondition
remove
()
Remove a named condition from the AND or OR condition list.
Returns
QBWhereCondition
Sample
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.remove("mycond")