QBWhereCondition

Overview

Where 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

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

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

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

var query = datasources.db.example_data.orders.createSelect();
query.where.add(query.columns.orderdate.isNull)

add(name, condition)

Add a named condition to the AND or OR condition list.

Parameters

Returns: QBLogicalCondition

Sample

var query = datasources.db.example_data.orders.createSelect();
query.where.add("mycond", query.columns.orderdate.isNull)

clear()

Clear the conditions in the query where-clause.

Returns: QBLogicalCondition

Sample

var query = datasources.db.example_data.orders.createSelect();
query.where.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 AND or OR condition list.

Parameters

  • String name The condition name.

Returns: QBLogicalCondition

Sample

var query = datasources.db.example_data.orders.createSelect();
query.where.remove("mycond")

Last updated