...
...
Table Row (tr) Table Head (th)Property Summary
...
...
Divcache DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING. THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR. Enter additional information related to this 'class' inside the {div} macro with 'id=description'
...
...
Table Cell (td)QBTableClause
...
true refresh 100d showRefresh true id doc title Refresh page showDate true retry Enable
servoy sReturnTypes 2 100% height: 30px; 2 Supported Clients sWordList SmartClient sWordList WebClient sWordList NGClient
servoy sSummary 12% 30% 58% height: 30px; 3 Property Summary Get the names for the conditions in the query where-clause.
...
Get query builder parent table clause, this may be a query or a join clause.
...
...
Get query builder parent.
...
...
...
...
...
servoy sSummary 12% 30% 58% height: 30px;
...
Table Head (th)Method Summary
...
3 Methods Summary Add a condition to the AND or OR condition list.
...
Add a named condition to the AND or OR condition list.
...
...
Clear the conditions in the query where-clause.
...
Table Cell (td)QBCondition
...
Get a named condition in the query where-clause.
...
...
...
Table Row (tr) Table Cell (td) DivClear the conditions in the query where-clause.
Table Row (tr) Table Cell (td)Sample Div Code Block/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.clear()
...
...
Table Row (tr) Table Cell (td)getCondition
Table Row (tr) Table Cell (td) DivGet a named condition in the query where-clause.
Table Row (tr) Table Cell (td)Sample Div Code Blockvar q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
var cond = q.where.getCondition(c)
}
...
...
Table Row (tr) Table Cell (td) DivRemove a named condition from the AND or OR condition list.
Table Row (tr) Table Cell (td)Sample Div Code Block/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.remove("mycond")
...
...
id Remove a named condition from the AND or OR condition list.
HTML Table
property class Colgroup Tag Column Table Row (tr)style servoy sDetail 2 100% height:30px ; Table Head (th)2 Property Details Table Body (tbody)id id conditionnames Table Row (tr)name td conditionnames Table Row (tr)id des Table Cell (td) Divclass sIndent Get the names for the conditions in the query where-clause. tr id td ret Returns
div sIndent clients
String [] Table Row (tr) Table Cell (td)Sample Div Code Blockvar q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
var cond = q.where.getCondition(c)
}
Table Row (tr) Table Cell (td) Table Body (tbody) Table Row (tr) Table Cell (td) DivGet query builder parent table clause, this may be a query or a join clause.
Table Row (tr) Table Cell (td)Sample Div Code Block/** @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)
Table Row (tr) Table Cell (td) Table Body (tbody) Table Row (tr) Table Cell (td) DivGet query builder parent.
Table Row (tr) Table Cell (td)Sample Div Code Block/** @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)
Table Row (tr) Table Cell (td)
...
id function class servoy sDetail
...
Table Row (tr) Table Head (th)Method Details
...
Table Row (tr) Table Cell (td) DivAdd a condition to the AND or OR condition list.
Table Row (tr) Table Cell (td)Parameters
Table Row (tr) Table Cell (td)Sample Div Code Block/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add(query.columns.orderdate.isNull)
...
...
Table Row (tr) Table Cell (td) DivAdd a named condition to the AND or OR condition list.
Table Row (tr) Table Cell (td)Parameters Div{ String } name - the name of the condition { QBCondition } condition - the condition to add
Table Row (tr) Table Cell (td)Sample Div Code Block/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add("mycond", query.columns.orderdate.isNull)
Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow parent name parent des sIndent Get query builder parent table clause, this may be a query or a join clause. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow root name root des sIndent Get query builder parent. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow
function servoy sDetail 2 100% height:30px 2 Methods Details add name add(condition) des sIndent Add a condition to the AND or OR condition list. prs Parameters
sIndent condition the condition to add ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow add name add(name, condition) des sIndent Add a named condition to the AND or OR condition list. prs Parameters
sIndent name the name of the condition condition the condition to add ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow clear name clear() des sIndent Clear the conditions in the query where-clause. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getCondition name getCondition(name) des sIndent Get a named condition in the query where-clause. prs Parameters
sIndent name The condition name. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow remove name remove(name) des sIndent Remove a named condition from the AND or OR condition list. prs Parameters
sIndent name The condition name. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow