Page History

Div

style	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.

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 Get the names for the conditions in the query where-clause.

Table Row (tr)

Table Cell (td)
QBTableClause

Table Cell (td)
parent 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

id
class	servoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Row (tr)

Table Cell (td)
QBWhereCondition

Table Cell (td)
add(condition) Add a condition to the AND or OR condition list.

Table Row (tr)

Table Cell (td)
QBWhereCondition

Table Cell (td)
add(name, condition) Add a named condition to the AND or OR condition list.

Table Row (tr)

Table Cell (td)
QBWhereCondition

Table Cell (td)
clear() Clear the conditions in the query where-clause.

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
getCondition() Get a named condition in the query where-clause.

Table Row (tr)

Table Cell (td)
QBWhereCondition

Table Cell (td)
remove() Remove a named condition from the AND or OR condition list.

HTML Table

id	property
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

Property Details

Table Body (tbody)

id	conditionnames

Table Row (tr)

id	name

Table Cell (td)
conditionnames

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

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 Table

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

Child pages

Versions Compared

Old Version 11

New Version Current

Key

conditionnames

parent

root

add

add

clear

getCondition

remove