Page History

Divcache
id
class	servoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

Table Row (tr)

Table Cell (td)
String[]

Table Cell (td)conditionnames

styleindex	display:none

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' Div

id	description

HTML Table

true
refresh	100d
showRefresh	true
id	doc
title	Refresh page
showDate	true
retry	Enable

idclass

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

Table Cell (td)
QBTableClause

Table Cell (td)parent

servoy sSummary

12%

30%

58%

height: 30px;

3

Property Summary

Get the names for the conditions in the query where-clause.

Table Row (tr)

Get query builder parent table clause, this may be a query or a join clause.

Table Row (tr)

Table Cell (td)
QBSelect

Table Cell (td)root

Get query builder parent.

HTML Table

Colgroup Tag

Col

width	80px

Col

Table Head (thead) Table Row (tr)style

servoy sSummary

Table Row (tr)

Table Cell (td)
QBWhereCondition

Table Cell (td)add(condition)

12%

30%

58%

height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Row (tr)

Table Cell (td)
QBWhereCondition

Table Cell (td)add(name, condition)

3

Methods Summary

Add a condition to the AND or OR condition list.

Add a named condition to the AND or OR condition list.

Table Row (tr)

Table Cell (td)
QBWhereCondition

Table Cell (td)clear()
Table Cell (td)getCondition()

Clear the conditions in the query where-clause.

Table Row (tr)

Table Cell (td)
QBCondition

Table Row (tr)

Table Cell (td)
QBWhereCondition

Table Cell (td)remove()

Get a named condition in the query where-clause.

Remove a named condition from the AND or OR condition list.

table

id

propertyclass Colgroup Tag Colcolspanservoy sDetail2width100%

Col

Table Head (thead) Table Row (tr)style

height:30px

; Table Head (th)colspan

2

Property Details

Table Body (tbody)idid

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.

Table Row (tr)id

ret Table Cell (td)
ReturnsdivsIndentclients
class sIndent
String[] Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
var q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
	var cond = q.where.getCondition(c)
}
 Table Row (tr)
class lastDetailRow
 Table Cell (td)
 
 Table Body (tbody)
id parent
 Table Row (tr)
id name
 Table Cell (td)
parent
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Get query builder parent table clause, this may be a query or a join clause.
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
QBTableClause
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
/** @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)
class lastDetailRow
 Table Cell (td)
 
 Table Body (tbody)
id root
 Table Row (tr)
id name
 Table Cell (td)
root
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Get query builder parent.
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
QBSelect
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
/** @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)
class lastDetailRow
 Table Cell (td)
 
 HTML Tableid function
class servoy sDetail
 Colgroup Tag
 Col
colspan 2
width 100%
 Col
 Table Head (thead)
 Table Row (tr)
style height: 30px;
 Table Head (th)
colspan 2
Method Details
 Table Body (tbody)
id add-QBCondition
 Table Row (tr)
id name
 Table Cell (td)
add
 Table Row (tr)
id sig
 Table Cell (td)
 Span
style margin-right: 5px;
QBWhereCondition
 Span
style font-weight: bold;
add
 Span
(condition)
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Add a condition to the AND or OR condition list.
 Table Row (tr)
id prs
 Table Cell (td)
Parameters
 Div
class sIndent
{QBCondition} condition - the condition to add
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
QBWhereCondition
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add(query.columns.orderdate.isNull)
 Table Row (tr)
class lastDetailRow
 Table Cell (td)
 
 Table Body (tbody)
id add-String_QBCondition
 Table Row (tr)
id name
 Table Cell (td)
add
 Table Row (tr)
id sig
 Table Cell (td)
 Span
style margin-right: 5px;
QBWhereCondition
 Span
style font-weight: bold;
add
 Span
(name, condition)
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Add a named condition to the AND or OR condition list.
 Table Row (tr)
id prs
 Table Cell (td)
Parameters
 Div
class sIndent
{String} name - the name of the condition
{QBCondition} condition - the condition to add
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
QBWhereCondition
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add("mycond", query.columns.orderdate.isNull)
 Table Row (tr)
class lastDetailRow
 Table Cell (td)
 
 Table Body (tbody)
id clear
 Table Row (tr)
id name
 Table Cell (td)
clear
 Table Row (tr)
id sig
 Table Cell (td)
 Span
style margin-right: 5px;
QBWhereCondition
 Span
style font-weight: bold;
clear
 Span
()
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Clear the conditions in the query where-clause.
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
QBWhereCondition
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.clear()
 Table Row (tr)
class lastDetailRow
 Table Cell (td)
 
 Table Body (tbody)
id getCondition
 Table Row (tr)
id name
 Table Cell (td)
getCondition
 Table Row (tr)
id sig
 Table Cell (td)
 Span
style margin-right: 5px;
QBCondition
 Span
style font-weight: bold;
getCondition
 Span
()
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Get a named condition in the query where-clause.
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
QBCondition
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
var q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
	var cond = q.where.getCondition(c)
}
 Table Row (tr)
class lastDetailRow
 Table Cell (td)
 
 Table Body (tbody)id remove
 Table Row (tr)
id name
 Table Cell (td)
remove
 Table Row (tr)
id sig
 Table Cell (td)
 Span
style margin-right: 5px;
QBWhereCondition
 Span
style font-weight: bold;
remove
 Span
()
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Remove a named condition from the AND or OR condition list.
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
QBWhereCondition
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.remove("mycond")
 Table Row (tr)class lastDetailRow
 Table Cell (td) Supported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowparentnameparentdessIndentGet query builder parent table clause, this may be a query or a join clause.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowrootnamerootdessIndentGet query builder parent.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRow
functionservoy sDetail2100%height:30px2Methods Detailsaddname
add(condition)dessIndentAdd a condition to the AND or OR condition list.prsParameters
sIndentconditionthe condition to addretReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowaddnameadd(name, condition)dessIndentAdd a named condition to the AND or OR condition list.prsParameters
sIndentnamethe name of the conditionconditionthe condition to addretReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowclearnameclear()dessIndentClear the conditions in the query where-clause.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowgetConditionnamegetCondition(name)dessIndentGet a named condition in the query where-clause.prsParameters
sIndentnameThe condition name.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowremovenameremove(name)dessIndentRemove a named condition from the AND or OR condition list.prsParameters
sIndentnameThe condition name.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRow

Child pages

Versions Compared

Old Version 10

New Version Current

Key

conditionnames

parent

root

add

add

clear

getCondition

remove

parent

root

add(condition)

add(name, condition)

clear()

getCondition(name)

remove(name)