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 6
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.
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} 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} Unknown macro: {div} Get/set the distinct flag for the query.
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} Unknown macro: {div} Get query builder parent table clause, this may be a query or a join clause.
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} Unknown macro: {div} Get query builder parent.
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} Unknown macro: {div} Add an aggregate to the query result.
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} Unknown macro: {div} Add an aggregate with alias to the query result.
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} Unknown macro: {div} Add a column to the query result.
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} Unknown macro: {div} Add a column with alias to the query result.
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} Unknown macro: {div} Add a function result to the query result.
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} Unknown macro: {div} Add a function with alias result to the query result.
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} Unknown macro: {div} Add the tables' primary pk columns in alphabetical order to the query result.
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} Unknown macro: {div} Add a value to the query result.
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} Unknown macro: {div} Add a value with an alias to the query result.
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} Unknown macro: {div} Clear the columns in the query result.
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {tr} Unknown macro: {td}