Child pages
  • QBSorts
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 8 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}

QBSelect

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}

QBSelect

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}

QBSorts

Unknown macro: {td}

add(columnSortAsc)
Ad an ascending sorting on a column to the query sort.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBSorts

Unknown macro: {td}

add(functionSortAsc)
Ad an ascending sorting on a column to the query sort.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBSorts

Unknown macro: {td}

add(sort)
Ad a sorting on a column to the query sort.

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBSorts

Unknown macro: {td}

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

Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}

QBSorts

Unknown macro: {td}

clear()
Clear the sorting clause for the query.


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}
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: {div}

QBSelect

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}
Unknown macro: {div}

Get query builder parent.

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBSelect

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}

QBSorts

Unknown macro: {span}

add

Unknown macro: {span}

(columnSortAsc)

Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {div}

Ad an ascending sorting on a column to the query sort.

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{QBColumn} columnSortAsc – column to sort by

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBSorts

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.sort.add(query.columns.orderid)
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}

QBSorts

Unknown macro: {span}

add

Unknown macro: {span}

(functionSortAsc)

Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {div}

Ad an ascending sorting on a column to the query sort.

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{QBFunction} functionSortAsc – function to add

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBSorts

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.sort.add(query.columns.orderid)
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}

QBSorts

Unknown macro: {span}

add

Unknown macro: {span}

(sort)

Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {div}

Ad a sorting on a column to the query sort.

Unknown macro: {tr}
Unknown macro: {td}

Parameters

Unknown macro: {div}

{QBSort} sort – the sort to add

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBSorts

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.sort.add(query.columns.orderid.desc)
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}

QBSorts

Unknown macro: {span}

addPk

Unknown macro: {span}

()

Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {div}

Add the tables' primary pk columns in alphabetical order to the query sort.

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBSorts

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.sort.addPk()
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}

QBSorts

Unknown macro: {span}

clear

Unknown macro: {span}

()

Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {div}

Clear the sorting clause for the query.

Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

QBSorts

Unknown macro: {tr}
Unknown macro: {td}

Sample

Unknown macro: {div}
query.sort.clear()
Unknown macro: {tr}
Unknown macro: {td}
  • No labels