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

Table Cell (td)and

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

idclass

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Property SummaryCreate an AND-condition to add conditions to.

Table Row (tr)

Table Cell (td)
QBColumns

Table Cell (td)
columns Get columns from query

Table Row (tr)

Table Cell (td)
QBFunctions

Table Cell (td)functions

Table Row (tr)

Table Cell (td)
QBGroupBy

Table Cell (td)groupBy

Get all the columns of the datasource that can be used for this query (select or where clause)

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

Get the group by clause from a query

Table Row (tr)

Table Cell (td)
QBLogicalCondition

Table Cell (td)having

Table Cell (td)joins

Get the having-part of the query, used to add conditions.

Table Row (tr)

Table Cell (td)
QBJoins

Table Cell (td)or

Get the joins clause of this table based clause.

Table Row (tr)

Table Cell (td)
QBLogicalCondition

Create an OR-condition to add conditions to.

Table Row (tr)

Table Cell (td)
QBParameters

Table Cell (td)params

Get the named parameters from a query.

Table Row (tr)

Table Cell (td)
QBTableClause

Table Cell (td)parent

result

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

Table Row (tr)

Table Cell (td)
QBResult

Table Cell (td)

Table Row (tr)

Table Cell (td)
QBSelect

Table Cell (td)root

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

Table Cell (td)sort

Get query builder parent.

Table Row (tr)

Table Cell (td)
QBSorts

Get the sorting part of the query.

Table Row (tr)

Table Cell (td)
QBWhereCondition

Table Cell (td)where

Get the where-part of the query, used to add conditions.

HTML Table

Colgroup Tag

Col

width	80px

Col

Table Head (thead) Table Row (tr)style

servoy sSummary

Table Row (tr)

Table Cell (td)
QBSelect

Table Cell (td)clearHaving()

12%

30%

58%

height: 30px;

Table Head (th)

colspan	2

Method Summary

3

Methods Summary

Clear the having-part of the query.

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)exists()

Table Cell (td)getColumn(name)

Get an exists-condition from a subquery

Table Row (tr)

Table Cell (td)
QBColumn

Get a column from the table.

Table Row (tr)

Table Cell (td)
QBColumn

Table Cell (td)getColumn(columnTableAlias, name)
Table Row (tr)

Table Cell (td)
QBParameter

Table Cell (td)getParameter()

Get a column from the table with given alias.

Returns the datasource for this.

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

. Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)not(cond)

Table Cell (td)
QBCondition

Table Cell (td)not(cond)

.

Returns the table alias for this.

Create an negated condition.

Table Row (tr)

Create an negated condition.

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

and

Table Row (tr)

name

td

and

Table Row (tr)id

des

Table Cell (td) Divclass

sIndent

Create an AND-condition to add conditions to.

Table Row (tr)idtd

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBLogicalCondition Table Row (tr)

id	sam

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

SmartClient,WebClient,NGClient

sam

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

sIdent

javascript

lastDetailRow

columns

name

columns

des

sIndent

Get all the columns of the datasource that can be used for this query (select or where clause)

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

functions

name

functions

des

sIndent

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

td

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBFunctions Table Row (tr)

id	sam

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

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

sIdent

javascript

lastDetailRow

groupBy

name

groupBy

des

sIndent

Get the group by clause from a query

Table Row (tr)idtd

ret

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

QBGroupBy Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td)

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

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)

sIdent

javascript

lastDetailRow

having

name

having

des

sIndent

Get the having-part of the query, used to add conditions.

Table Row (tr)id

The conditions added here are AND-ed.

td

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBLogicalCondition Table Row (tr)

id	sam

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

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

sIdent

javascript

lastDetailRow

joins

name

joins

des

sIndent

Get the joins clause of this table based clause.

Table Row (tr)id

Joins added to this clause will be based on this table clauses table.

td

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBJoins Table Row (tr)

id	sam

SmartClient,WebClient,NGClient

sam

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

Table Row (tr)id

sIdent

javascript

lastDetailRow

or

name

or

des

sIndent

Create an OR-condition to add conditions to.

td

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBLogicalCondition Table Row (tr)

id	sam

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

SmartClient,WebClient,NGClient

sam

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

sIdent

javascript

lastDetailRow

params

name

params

des

sIndent

Get the named parameters from a query.

Table Row (tr)idtd

ret

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

QBParameters Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td)

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

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

sIdent

javascript

lastDetailRow

parent

name

parent

des

sIndent

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

td

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	result

Table Row (tr)

id	name

Table Cell (td)
result

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)

Table Row (tr)id

sIdent

javascript

lastDetailRow

result

name

result

des

sIndent

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

td

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBResult 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

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

sIdent

javascript

lastDetailRow

root

name

root

des

sIndent

Get query builder parent.

Table Row (tr)id

ret

Table Cell (td)

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBSelect Table Row (tr)

id	sam

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

SmartClient,WebClient,NGClient

sam

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

sIdent

javascript

lastDetailRow

sort

name

sort

des

sIndent

Get the sorting part of the query.

td

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBSorts Table Row (tr)

id	sam

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

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

sIdent

javascript

lastDetailRow

where

name

where

des

sIndent

Get the where-part of the query, used to add conditions.

Table Row (tr)id

The conditions added here are AND-ed.

td

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBWhereCondition Table Row (tr)

id	sam

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

SmartClient,WebClient,NGClient

sam

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

sIdent

javascript

lastDetailRow

functionservoy sDetail2100%height:30px2Methods DetailsclearHavingname

clearHaving()

des

sIndent

Clear the having-part of the query.

Table Row (tr)id

ret

td

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBSelect Table Row (tr)

id	sam

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

SmartClient,WebClient,NGClient

sam

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

sIdent

javascript

lastDetailRow

exists

name

exists(query)

des

sIndent

Get an exists-condition from a subquery

prs

Table Row (tr)

id	ret

td

Parameters

sIndent

query

the sub query

ret

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

QBCondition Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td)

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

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

sIdent

javascript

lastDetailRow

getColumn

name

getColumn(name)

des

sIndent

Get a column from the table.

Table Row (tr)idtd

prs

Parameters

Divclass

sIndent{String} name - the name of column to get Table Row (tr)idret

Table Cell (td)

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBColumn Table Row (tr)

id	sam

Span

style	margin-right: 5px;

QBColumn

Span

style	font-weight: bold;

getColumn

Span

SmartClient,WebClient,NGClient

sam

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)

sIdent

javascript

lastDetailRow

getColumn

name

getColumn(columnTableAlias, name)

Table Row (tr)idclass

des

Table Cell (td) Div

sIndent

Get a column from the table with given alias.

Table Row (tr)id

The alias may be of the main table or any level deep joined table.

td

prs

Parameters

Divclass

sIndent{String} columnTableAlias - the alias for the table
{String} name - the name of column to get Table Row (tr)idtdret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBColumn Table Row (tr)

id	sam

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

SmartClient,WebClient,NGClient

sam

Sample

Div

class	sIndent

Code Block

language	javascript

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

sIdent

javascript

lastDetailRow

getDataSource

name

getDataSource()

des

sIndent

Returns the datasource for this.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getParameter

name

getParameter(name)

des

sIndent

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

prs

Table Row (tr)

id	ret

td

Parameters

sIndent

name

the name of the parameter

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

QBParameter Table Row (tr)

id	sam

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)

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

sIdent

javascript

lastDetailRow

getTableAlias

name

getTableAlias()

des

sIndent

Returns the table alias for this.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

not

name

not(cond)

des

sIndent

Create an negated condition.

prs

Parameters

sIndent

cond

the condition to negate

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

not

name

not(cond)

des

sIndent

Create an negated condition.

prs

Parameters

sIndent

cond

the logical condition to negate

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

Child pages

Page History

Versions Compared

Old Version 13

New Version 14

Key

and

columns

functions

columns

functions

groupBy

groupBy

having

having

joins

joins

or

or

params

params

parent

parent

result

result

root

root

sort

sort

where

where

clearHaving

clearHaving()

exists

exists(query)

getColumn

getColumn(name)

getColumn

getColumn(columnTableAlias, name)

getParameter

getDataSource()

getParameter(name)

not

not

getTableAlias()

not(cond)

not(cond)