Servoy 7.x.x Documentation
Child pages
  • QBResult
Skip to end of metadata
Go to start of metadata

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

Compare with Current View Page History

« Previous Version 10 Next »


Property Summary
Boolean distinct
Get/set the distinct flag for the query.
QBSelect parent
Get query builder parent table clause, this may be a query or a join clause.
QBSelect root
Get query builder parent.

Method Summary
QBResult add(aggregate)
Add an aggregate to the query result.
QBResult add(aggregate, alias)
Add an aggregate with alias to the query result.
QBResult add(column)
Add a column to the query result.
QBResult add(column, alias)
Add a column with alias to the query result.
QBResult add(func)
Add a function result to the query result.
QBResult add(func, alias)
Add a function with alias result to the query result.
QBResult addPk()
Add the tables' primary pk columns in alphabetical order to the query result.
QBResult addValue(value)
Add a value to the query result.
QBResult addValue(value, alias)
Add a value with an alias to the query result.
QBResult clear()
Clear the columns in the query result.

Property Details
distinct
Get/set the distinct flag for the query.
Returns
Boolean
Sample
query.result.distinct = true
parent
Get query builder parent table clause, this may be a query or a join clause.
Returns
QBSelect
Sample
/** @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)
root
Get query builder parent.
Returns
QBSelect
Sample
/** @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)

Method Details
add
QBResult add (aggregate)
Add an aggregate to the query result.
Parameters
{QBAggregate} aggregate - the aggregate to add to result
Returns
QBResult
Sample
query.result.add(query.columns.label_text.max)
add
QBResult add (aggregate, alias)
Add an aggregate with alias to the query result.
Parameters
{QBAggregate} aggregate - the aggregate to add to result
{String} alias - aggregate alias
Returns
QBResult
Sample
query.result.add(query.columns.item_count.max, 'maximum_items')
add
QBResult add (column)
Add a column to the query result.
Parameters
{QBColumn} column - column to add to result
Returns
QBResult
Sample
query.result.add(query.columns.custname)
add
QBResult add (column, alias)
Add a column with alias to the query result.
Parameters
{QBColumn} column - column to add to result
{String} alias - column alias
Returns
QBResult
Sample
query.result.add(query.columns.custname, 'customer_name')
add
QBResult add (func)
Add a function result to the query result.
Parameters
{QBFunction} func - the function to add to the result
Returns
QBResult
Sample
query.result.add(query.columns.custname.upper())
add
QBResult add (func, alias)
Add a function with alias result to the query result.
Parameters
{QBFunction} func - the function to add to the result
{String} alias - function alias
Returns
QBResult
Sample
query.result.add(query.columns.custname.upper(), 'customer_name')
addPk
QBResult addPk ()
Add the tables' primary pk columns in alphabetical order to the query result.
Returns
QBResult
Sample
query.result.addPk()
addValue
QBResult addValue (value)
Add a value to the query result.
Parameters
{Object} value - value add to result
Returns
QBResult
Sample
query.result.addValue(100)
addValue
QBResult addValue (value, alias)
Add a value with an alias to the query result.
Parameters
{Object} value - value add to result
{String} alias - value alias
Returns
QBResult
Sample
query.result.addValue(100, 'myvalue')
clear
QBResult clear ()
Clear the columns in the query result.
Returns
QBResult
Sample
query.result.clear()

  • No labels