Child pages
  • QBLogicalCondition
Skip to end of metadata
Go to start of metadata


Property Summary
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
QBLogicalCondition #add()
Add a condition to the AND or OR condition list.

Property Details
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

QBLogicalCondition add ()

Add a condition to the AND or OR condition list.
<pre>
query.where().add(query.getColumn("flag").eq(new Integer(1))).add(query.getColumn("value").isNull());
</pre>
Returns
QBLogicalCondition
Sample
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add(query.columns.orderdate.isNull)
  • No labels