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.



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")