QBLogicalCondition

Nov 29, 2023 14:16

Supported Clients
SmartClient WebClient NGClient

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.

Methods Summary
QBLogicalCondition	add(condition)	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
Supported Clients SmartClient,WebClient,NGClient
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.
Returns QBSelect
Supported Clients SmartClient,WebClient,NGClient
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 Details

Add a condition to the AND or OR condition list.

Parameters

QBCondition

condition

the condition to add

Returns

QBLogicalCondition

Supported Clients

SmartClient,WebClient,NGClient

Sample

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