Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Skip to end of banner Go to start of banner

QBResult

Skip to end of metadata

Created by Servoy Docs, last modified on Aug 30, 2013

Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Unknown macro: {div}

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'

Unknown macro: {div}

Unknown macro: {table}

{column:width=80px|padding=0px}{column}{column}{column}

Unknown macro: {tr}

Unknown macro: {th}

Property Summary

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

distinct
Get/set the distinct flag for the query.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

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

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

root
Get query builder parent.

Unknown macro: {table}

{column:width=80px|padding=0px}{column}{column}{column}

Unknown macro: {tr}

Unknown macro: {th}

Method Summary

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

add(aggregate)
Add an aggregate to the query result.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

add(aggregate, alias)
Add an aggregate with alias to the query result.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

add(column)
Add a column to the query result.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

add(column, alias)
Add a column with alias to the query result.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

add(func)
Add a function result to the query result.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

add(func, alias)
Add a function with alias result to the query result.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

addPk()
Add the tables' primary pk columns in alphabetical order to the query result.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

addValue(value)
Add a value to the query result.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

addValue(value, alias)
Add a value with an alias to the query result.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

clear()
Clear the columns in the query result.

Unknown macro: {table}

{column:width=100%|padding=0px}{column}

Unknown macro: {tr}

Unknown macro: {th}

Property Details

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

distinct

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

query.result.distinct = true

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

parent

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

/** @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)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

root

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

/** @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)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {table}

{column:width=100%|padding=0px}{column}

Unknown macro: {tr}

Unknown macro: {th}

Method Details

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

add

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

add

Unknown macro: {span}

(aggregate)

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{QBAggregate} aggregate – the aggregate to add to result

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

query.result.add(query.columns.label_text.max)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

add

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

add

Unknown macro: {span}

(aggregate, alias)

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{QBAggregate} aggregate – the aggregate to add to result
{String} alias – aggregate alias

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

query.result.add(query.columns.item_count.max, 'maximum_items')

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

add

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

add

Unknown macro: {span}

(column)

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{QBColumn} column – column to add to result

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

query.result.add(query.columns.custname)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

add

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

add

Unknown macro: {span}

(column, alias)

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{QBColumn} column – column to add to result
{String} alias – column alias

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

query.result.add(query.columns.custname, 'customer_name')

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

add

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

add

Unknown macro: {span}

(func)

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{QBFunction} func – the function to add to the result

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

query.result.add(query.columns.custname.upper())

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

add

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

add

Unknown macro: {span}

(func, alias)

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{QBFunction} func – the function to add to the result
{String} alias – function alias

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

query.result.add(query.columns.custname.upper(), 'customer_name')

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

addPk

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

addPk

Unknown macro: {span}

()

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

query.result.addPk()

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

addValue

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

addValue

Unknown macro: {span}

(value)

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} value – value add to result

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

query.result.addValue(100)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

addValue

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

addValue

Unknown macro: {span}

(value, alias)

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{Object} value – value add to result
{String} alias – value alias

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

query.result.addValue(100, 'myvalue')

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

clear

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

clear

Unknown macro: {span}

()

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

query.result.clear()

Unknown macro: {tr}

Unknown macro: {td}

No labels