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 4
Next »
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
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} distinct
Get/set the distinct flag for the query.
Unknown macro: {tbody} Unknown macro: {tr} 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} 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} add(aggregate)
Add an aggregate to the query result.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} add(aggregate, alias)
Add an aggregate with alias to the query result.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} add(column)
Add a column to the query result.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} add(column, alias)
Add a column with alias to the query result.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} add(func)
Add a function result to the query result.
Unknown macro: {tbody} Unknown macro: {tr} 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} addPk()
Add the tables' primary pk columns in alphabetical order to the query result.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} addValue(value)
Add a value to the query result.
Unknown macro: {tbody} Unknown macro: {tr} 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} 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: {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: {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} Returns
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} 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: {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} 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: {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} 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: {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} 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: {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} 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: {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} 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: {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} addPk
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
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} 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: {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} 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: {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} clear
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {tr} Unknown macro: {td}