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