Page History

...

padding	0px
width	80px

...

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

...

Table Cell (td)
QBSelect

...

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'

Divcache

styleindex	display:none

...

id	description

...

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

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Property SummaryGet query builder parent table clause, this may be a query or a join clause.

...

Table Cell (td)
QBSelect

...

padding	0px
width	80px

...

Get query builder parent.

...

Table Cell (td)
QBGroupBy

...

servoy sSummary

12%

30%

58%

height: 30px;

...

Table Head (th)

colspan	2

Method Summary

...

Table Cell (td)
QBGroupBy

...

3

Methods Summary

Add column name to group-by clause.

...

Table Cell (td)
QBGroupBy

...

Add column name to group-by clause.

...

Add the tables' primary pk columns in alphabetical order to the group by clause.

...

Table Cell (td)
QBGroupBy

...

servoy sDetail

2

Property Details

parent

name

td

parent

id

des

sIndent

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

idtd

retReturnsdivsIndentclientsclasstd
Supported Clients
sIndent

SmartClient,WebClient,NGClient

sam

Sample

id

Clear the to group-by clause.

HTML Table

property

class

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style

2100%

height:30px

;

Table Head (th)

colspan	1

Table Body (tbody)

id

Table Row (tr)

Table Cell (td)

Div

class

Table Row (tr)

QBSelect

Table Row (tr)

id	sam

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)

...

id	function
class	servoy sDetail

...

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Method Details

...

id	add-QBColumn

Table Row (tr)

id	name

Table Cell (td)
add

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBGroupBy

Span

style	font-weight: bold;

add

Span
(column)

...

id	des

...

class	sIndent

Add column name to group-by clause.

...

sIdent

javascript

lastDetailRow

root

name

root

des

sIndent

Get query builder parent.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

functionservoy sDetail2100%height:30px2Methods Detailsaddname

add(column)

des

sIndent

Add column name to group-by clause.

Same as query.groupBy().add(join.getColumn("value"))

...

prs

...

Parameters

...

sIndent

...

column

...

the column to add to the query condition

...

ret

...

Returns

...

sIndent

clients

...

Supported Clients

sIndent

...

id	sam

...

class	lastDetailRow

...

id	add-QBFunction

Table Row (tr)

id	name

Table Cell (td)
add

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBGroupBy

Span

style	font-weight: bold;

add

Span
(function)

...

id	des

...

class	sIndent

Add column name to group-by clause.

...

SmartClient,WebClient,NGClient

sam

Sample

...

class	sIndent

...

Code Block

language	javascript

/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.groupBy.add(query.columns.orderid) // 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

add

name

add(function)

des

sIndent

Add column name to group-by clause.

Same as query.groupBy().add(join.getColumn("value"))

...

prs

...

Parameters

...

sIndent

...

function

...

the function to add to the query

...

ret

...

Returns

...

sIndent

clients

...

Supported Clients

sIndent

...

SmartClient,WebClient,NGClient

sam

...

class	lastDetailRow

...

id	addPk

Table Row (tr)

id	name

Table Cell (td)
addPk

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBGroupBy

Span

style	font-weight: bold;

addPk

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Add the tables' primary pk columns in alphabetical order to the group by clause.

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)

...

class	lastDetailRow

...

id	clear

Table Row (tr)

id	name

Table Cell (td)
clear

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

QBGroupBy

Span

style	font-weight: bold;

clear

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Clear the to group-by clause.

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

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

...

class	lastDetailRow

...

Sample

...

class	sIndent

...

Code Block

language	javascript

/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.groupBy.add(query.columns.orderid) // 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

addPk

name

addPk()

des

sIndent

Add the tables' primary pk columns in alphabetical order to the group by clause.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

clear

name

clear()

des

sIndent

Clear the to group-by clause.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

Child pages

Versions Compared

Old Version 10

New Version Current

Key

parent

des

root

add

root

add(column)

add

add(function)

addPk

clear

addPk()

clear()