| 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(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 |
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 |
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 (condition) |
Add a condition to the AND or OR condition list.
|
| Parameters {QBCondition} condition - the condition to add
|
| Returns |
Sample/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add(query.columns.orderdate.isNull)
|
Overview
Content Tools
Activity