...
...
Table Row (tr) Table Head (th)Property Summary
...
Table Cell (td)QBTableClause
...
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'
...
...
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 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
table 3 Methods Summary Add a condition to 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.add(query.columns.orderdate.isNull)
...
...
id
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 parent Table Row (tr)name td parent Table Row (tr)id des Table Cell (td) Divclass sIndent Get query builder parent table clause, this may be a query or a join clause. Table Row (tr)idtd ret Returns
div sIndent clients
class id Supported Clients
sIndent QBTableClause Table Row (tr)SmartClient,WebClient,NGClient sam
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
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