Page History

...

HTML Table

id
class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBLogicalCondition

Table Cell (td)
#and and Create an AND-condition to add conditions to.

Table Row (tr)

Table Cell (td)
QBColumns

Table Cell (td)
#columns columns Get columns from query

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBFunctions

Table Cell (td)
#functions functions Get the functions clause from a query, used for functions that are not tied to a column.

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBGroupBy

Table Cell (td)
#groupBy groupBy Get the group by clause from a query

Table Row (tr)

Table Cell (td)
QBLogicalCondition

Table Cell (td)
#having having Get the having-part of the query, used to add conditions.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBJoins

Table Cell (td)
#joins joins Get the joins clause of this table based clause.

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBLogicalCondition

Table Cell (td)
#or or Create an OR-condition to add conditions to.

Table Row (tr)

Table Cell (td)
QBParameters

Table Cell (td)
#params params Get the named parameters from a query.

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBTableClause

Table Cell (td)
#parent parent Get query builder parent table clause, this may be a query or a join clause.

tbody

Table Row (tr)

Table Cell (td)
QBResult

Table Cell (td)
#result result Get the result part of the query, used to add result columns or values.

Table Row (tr)

Table Cell (td)
QBSelect

Table Cell (td)
#root root Get query builder parent.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBSorts

Table Cell (td)
#sort sort Get the sorting part of the query.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBWhereCondition

Table Cell (td)
#where where Get the where-part of the query, used to add conditions.

HTML Table

id
class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBSelect

Table Cell (td)
#clearHaving clearHaving() Clear the having-part of the query.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
#exists exists() Get an exists-condition from a subquery

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBColumn

Table Cell (td)
#getColumn getColumn(name) Get a column from the table.

Table Row (tr)

Table Cell (td)
QBColumn

Table Cell (td)
#getColumn getColumn(columnTableAlias, name) Get a column from the table with given alias.

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBParameter

Table Cell (td)
#getParameter getParameter() Get or create a parameter for the query, this used to parameterize queries.

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
#not not(cond) Create an negated condition.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
#not not(cond) Create an negated condition.

HTML Table

id	property
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Property Details

Table Body (tbody)

id	and

Table Row (tr)

id	name

Table Cell (td)
and

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create an AND-condition to add conditions to.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBLogicalCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

query.where.add(
	  query.or
	    .add(
	      query.and
		    .add(query.columns.flag.eq(1))
	    .add(query.columns.order_date.isNull)
		 )
	    .add(
	      query.and
	        .add(query.columns.flag.eq(2))
	        .add(query.column.order_date.gt(new Date()))
	     )
	);

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	columns

Table Row (tr)

id	name

Table Cell (td)
columns

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get columns from query

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBColumns

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

foundset.getQuery().columns

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	functions

Table Row (tr)

id	name

Table Cell (td)
functions

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get the functions clause from a query, used for functions that are not tied to a column.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBFunctions

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') //$NON-NLS-1$
query.where.add(query.columns.shipname.upper.eq(query.functions.upper('servoy'))) //$NON-NLS-1$
foundset.loadRecords(query)

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	groupBy

Table Row (tr)

id	name

Table Cell (td)
groupBy

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get the group by clause from a query

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBGroupBy

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.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.eq(0))
foundset.loadRecords(query)

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	having

Table Row (tr)

id	name

Table Cell (td)
having

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get the having-part of the query, used to add conditions.
The conditions added here are AND-ed.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBLogicalCondition

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.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.eq(0))
foundset.loadRecords(query)

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	joins

Table Row (tr)

id	name

Table Cell (td)
joins

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get the joins clause of this table based clause.
Joins added to this clause will be based on this table clauses table.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBJoins

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

foundset.getQuery().joins

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	or

Table Row (tr)

id	name

Table Cell (td)
or

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create an OR-condition to add conditions to.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBLogicalCondition

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

query.where.add(
	  query.or
	    .add(
	      query.and
		    .add(query.columns.flag.eq(1))
	    .add(query.columns.order_date.isNull)
		 )
	    .add(
	      query.and
	        .add(query.columns.flag.eq(2))
	        .add(query.column.order_date.gt(new Date()))
	     )
	);

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	params

Table Row (tr)

id	name

Table Cell (td)
params

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get the named parameters from a query.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBParameters

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.contact_id.eq(query.getParameter('mycontactid')))

...


	// load orders where contact_id = 100
	query.params['mycontactid'] = 100
	foundset.loadRecords(query)

...


	// load orders where contact_id = 200
	query.params['mycontactid'] = 200
	foundset.loadRecords(query)

...

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	result

Table Row (tr)

id	name

Table Cell (td)
result

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get the result part of the query, used to add result columns or values.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBResult

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

query.result.add(query.columns.company_id).add(query.columns.customerid)

...

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)

Table Body (tbody)

id	sort

Table Row (tr)

id	name

Table Cell (td)
sort

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get the sorting part of the query.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBSorts

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.sort
.add(query.joins.orders_to_order_details.columns.quantity.desc)
.add(query.columns.companyid)
foundset.loadRecords(query)

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	where

Table Row (tr)

id	name

Table Cell (td)
where

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get the where-part of the query, used to add conditions.
The conditions added here are AND-ed.

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

...

var query = foundset.getQuery()
query.where.add(query.columns.flag.eq(1))

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

HTML Table

id	function
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Method Details

Table Body (tbody)

id	clearHaving

Table Row (tr)

id	name

Table Cell (td)
clearHaving

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBSelect

Span

style	font-weight: bold;

clearHaving

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Clear the having-part of the query.

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

...

var q = foundset.getQuery()
q.where.add(q.columns.x.eq(100))
query.groupBy.clear.root.clearHaving()
foundset.loadRecords(q);

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	exists

Table Row (tr)

id	name

Table Cell (td)
exists

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

exists

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get an exists-condition from a subquery

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

...

foundset.query.where.add(query.exists(query2))

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getColumn-String

Table Row (tr)

id	name

Table Cell (td)
getColumn

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBColumn

Span

style	font-weight: bold;

getColumn

Span
(name)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get a column from the table.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} name

...

- the name of column to get

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBColumn

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

foundset.getQuery().getColumn('orderid')

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getColumn-String_String

Table Row (tr)

id	name

Table Cell (td)
getColumn

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBColumn

Span

style	font-weight: bold;

getColumn

Span
(columnTableAlias, name)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get a column from the table with given alias.
The alias may be of the main table or any level deep joined table.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} columnTableAlias

...

- the alias for the table
{String} name

...

- the name of column to get

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBColumn

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

foundset.getQuery().getColumn('orderid', 'opk')

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getParameter

Table Row (tr)

id	name

Table Cell (td)
getParameter

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBParameter

Span

style	font-weight: bold;

getParameter

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get or create a parameter for the query, this used to parameterize queries.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

QBParameter

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.contact_id.eq(query.getParameter('mycontactid')))

...


	// load orders where contact_id = 100
	query.params['mycontactid'] = 100
	foundset.loadRecords(query)

...


	// load orders where contact_id = 200
	query.params['mycontactid'] = 200
	foundset.loadRecords(query)

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	not-QBCondition

Table Row (tr)

id	name

Table Cell (td)
not

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

not

Span
(cond)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create an negated condition.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{QBCondition} cond

...

- the condition to negate

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

...

foundset.query.where.add(query.not(query.columns.flag.eq(1)))

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	not-QBLogicalCondition

Table Row (tr)

id	name

Table Cell (td)
not

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBCondition

Span

style	font-weight: bold;

not

Span
(cond)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Create an negated condition.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{QBLogicalCondition} cond

...

- the logical condition to negate

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

...

foundset.query.where.add(query.not(query.columns.flag.eq(1)))

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 9

New Version 10

Key

and

columns

functions

groupBy

having

joins

or

params

parent

result

root

sort

where

clearHaving

exists

getColumn

getColumn

getParameter

not

not