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[]
|
Samplevar 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 |
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 |
QBWhereCondition 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) |
add |
QBWhereCondition add (name, condition) |
Add a named condition to the AND or OR condition list.
|
Parameters |
Returns |
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 |
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 |
Samplevar 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 |
Sample/** @type {QBSelect<db:/example_data/orders>} */ var query = databaseManager.createSelect('db:/example_data/orders') query.where.remove("mycond") |
Overview
Content Tools
Activity