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 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}

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}

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}

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}

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}

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}

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}

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}

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