Child pages
  • QBWhereCondition
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 3 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}

String[]

Unknown macro: {td}

conditionnames
Get the names for the conditions in the query where-clause.

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

QBTableClause

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}

QBWhereCondition

Unknown macro: {td}

add(condition)
Add a condition to the AND or OR condition list.

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

QBWhereCondition

Unknown macro: {td}

add(name, condition)
Add a named condition to the AND or OR condition list.

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

QBWhereCondition

Unknown macro: {td}

clear()
Clear the conditions in the query where-clause.

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

QBCondition

Unknown macro: {td}

getCondition()
Get a named condition in the query where-clause.

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

QBWhereCondition

Unknown macro: {td}

remove()
Remove a named condition from the AND or OR condition list.


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}
conditionnames
Unknown macro: {tr}
Unknown macro: {td}

Returns

Unknown macro: {div}

String[]

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

Sample

Unknown macro: {div}
var q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
	var cond = q.where.getCondition(c)
}
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: {div}

QBTableClause

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}

QBWhereCondition

Unknown macro: {span}

add

Unknown macro: {span}

(condition)

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

Parameters

Unknown macro: {div}

{QBCondition} condition – the condition to add

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

Returns

Unknown macro: {div}

QBWhereCondition

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

Sample

Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add(query.columns.orderdate.isNull)
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}

QBWhereCondition

Unknown macro: {span}

add

Unknown macro: {span}

(name, condition)

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

Parameters

Unknown macro: {div}

{String} name – the name of the condition
{QBCondition} condition – the condition to add

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

Returns

Unknown macro: {div}

QBWhereCondition

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

Sample

Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add("mycond", query.columns.orderdate.isNull)
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}

QBWhereCondition

Unknown macro: {span}

clear

Unknown macro: {span}

()

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

Returns

Unknown macro: {div}

QBWhereCondition

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

Sample

Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.clear()
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
getCondition
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBCondition

Unknown macro: {span}

getCondition

Unknown macro: {span}

()

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

Returns

Unknown macro: {div}

QBCondition

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

Sample

Unknown macro: {div}
var q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
	var cond = q.where.getCondition(c)
}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
remove
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}

QBWhereCondition

Unknown macro: {span}

remove

Unknown macro: {span}

()

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

Returns

Unknown macro: {div}

QBWhereCondition

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

Sample

Unknown macro: {div}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.remove("mycond")
Unknown macro: {tr}
Unknown macro: {td}
  • No labels