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

...

Get query builder parent.

...

padding	0px
width	80px

...

servoy sSummary

12%

30%

58%

height: 30px;

...

Table Head (th)

colspan	2

Method Summary

...

Table Cell (td)
QBGroupBy

...

Table Cell (td)
QBGroupBy

...

3

Methods Summary

Add column name to group-by clause.

...

Add column name to group-by clause.

...

Table Cell (td)
QBGroupBy

...

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

...

Table Cell (td)
QBGroupBy

...

Clear the to group-by clause.

...

property

...

servoy sDetail

...

padding	0px
width	100%

...

2100%

height:30px

...

colspan	1

...

2

Property Details

...

parent

...

name

...

parent

...

des

...

sIndent

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

...

ret

...

Returns

...

sIndent

clients

...

Supported Clients

sIndent

...

id	sam

...

class	lastDetailRow

...

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)

...

class	lastDetailRow

...

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

Table Row (tr)

id	des

Table Cell (td) Div

class	sIndent

Add column name to group-by clause.

Same as

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)

id

prstdParameters
div

sIndent

{QBColumn}

column

–

the column to add to the query condition

td

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

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

Table Row (tr)

class

Table Row (tr)

id

QBGroupBy

Table Row (tr)

id	sam

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

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)

Table Row (tr)

id	des

Table Cell (td) Div

class	sIndent

Add column name to group-by clause.

Same as

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

tr

idprs Table Cell (td)
Parameters
divclasssIndent{QBFunction} function – the function to add to the query Table Row (tr)idtdret
ReturnsdivsIndentclientsclasstd
Supported Clients
sIndentQBGroupBy Table Row (tr)id sam
 Table Row (tr)class lastDetailRow
 Table Cell (td) Table Body (tbody)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)
 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;
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);
 Table Row (tr)class lastDetailRow
tdSmartClient,WebClient,NGClientsamSample Div
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)
sIdentjavascriptlastDetailRowaddPknameaddPk()dessIndentAdd the tables' primary pk columns in alphabetical order to the group by clause.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowclearnameclear()dessIndentClear the to group-by clause.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRow

Child pages

Versions Compared

Old Version 9

New Version Current

Key

parent

root

add

root

add(column)

add

add(function)

addPk

clear

addPk()

clear()