Page History

Divcache

Div

id	description

HTML Table

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.

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

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

idclassservoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead) Table Row (tr)style Table Row (tr)

Table Cell (td)
QBWhereCondition

Table Cell (td)add(condition)

servoy sSummary

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

tdid

conditionnames

Table Row (tr)

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)

Returns

div

Table Row (tr)

id	name

Table Cell (td)
parent

Table Row (tr)

id	des

Table Cell (td) Div

class	sIndent

sIndent

clients

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

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.

Table Row (tr)idtd

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBTableClause Table Row (tr)

id	sam

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

SmartClient,WebClient,NGClient

sam

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)

sIdent

javascript

lastDetailRow

root

name

root

des

sIndent

Get query builder parent.

Table Row (tr)idtd

ret

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

QBSelect Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td)

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

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 Table

id	function
class	servoy sDetail

sIdent

javascript

lastDetailRow

functionservoy sDetail2100%height:30px2Methods Detailsaddname

add(condition)

des

sIndent

Add a condition to the AND or OR condition list.

Table Row (tr)id

prs

td

Parameters

Divclass

sIndent{QBCondition} condition - the condition to add Table Row (tr)idret

Table Cell (td)

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

QBWhereCondition Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td)

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

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)

sIdent

javascript

lastDetailRow

add

name

add(name, condition)

Table Row (tr)id Table Cell (td) Divclass

des

sIndent

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

Table Row (tr)idtd

prs

Parameters

div

classsIndent{String} name - the name of the condition
{QBCondition} condition - the condition to add Table Row (tr)idtdret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBWhereCondition Table Row (tr)

id	sam

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

SmartClient,WebClient,NGClient

sam

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)

sIdent

javascript

lastDetailRow

clear

name

clear()

des

sIndent

Clear the conditions in the query where-clause.

Table Row (tr)idtd

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBWhereCondition Table Row (tr)

id	sam

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

SmartClient,WebClient,NGClient

sam

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()

sIdent

javascript

lastDetailRow

getCondition

name

getCondition(name)

des

sIndent

Get a named condition in the query where-clause.

prs

Table Row (tr)id

Parameters

sIndent

name

The condition name.

ret

Table Cell (td)

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

QBCondition Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td)

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

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)
}

sIdent

javascript

lastDetailRow

remove

name

remove(name)

des

sIndent

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

prs

Table Row (tr)

id	ret

td

Parameters

sIndent

name

The condition name.

ret

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

QBWhereCondition Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td) Table Row (tr)

class	lastDetailRow

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")

sIdent

javascript

lastDetailRow

Child pages

Versions Compared

Old Version 12

New Version 13

Key

conditionnames

parent

parent

root

root

add

add(condition)

add

add(name, condition)

clear

clear()

getCondition

getCondition(name)

remove

remove(name)