{div:style=display:none}
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'{div}
{div:id=description}{div}\\ 

{table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Property Summary{th}{tr}{tbody}{tr}{td}[QBFunction]{td}{td}[#abs]
Create abs(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBSort]{td}{td}[#asc]
Create an ascending sort expression{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#avg]
Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#bit_length]
Create bit\_length(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#ceil]
Create ceil(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#count]
Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#day]
Extract day from date{td}{tr}{tbody}{tbody}{tr}{td}[QBSort]{td}{td}[#desc]
Create an descending sort expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#floor]
Create floor(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#hour]
Extract hour from date{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#isNull]
Compare column with null.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#len]
Create length(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#lower]
Create lower(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#max]
Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#min]
Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#minute]
Extract minute from date{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#month]
Extract month from date{td}{tr}{tbody}{tbody}{tr}{td}[QBColumn]{td}{td}[#not]
Create a negated condition.{td}{tr}{tbody}{tbody}{tr}{td}[QBTableClause]{td}{td}[#parent]
Get query builder parent table clause, this may be a query or a join clause.{td}{tr}{tbody}{tbody}{tr}{td}[QBSelect]{td}{td}[#root]
Get query builder parent.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#round]
Create round(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#second]
Extract second from date{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#sqrt]
Create sqrt(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#sum]
Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#trim]
Create trim(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#upper]
Create upper(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#year]
Extract year from date{td}{tr}{tbody}{table}\\ 

{table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tr}{td}[QBCondition]{td}{td}[#between]\(value1, value2)
Compare column to a range of 2 values or other columns.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#cast]\(type)
Create cast(column, type) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#concat]\(arg)
Concatename with value{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#divide]\(arg)
Divide by value{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#eq]\(value)
Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#ge]\(value)
Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#gt]\(value)
Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#isin]\(query)
Compare column with subquery result.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#isin]\(values)
Compare column with values.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#le]\(value)
Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#like]\(pattern)
Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#like]\(pattern, escape)
Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#locate]\(arg)
Create locate(arg) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#locate]\(arg, start)
Create locate(arg, start) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#lt]\(value)
Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#minus]\(arg)
Subtract value{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#mod]\(arg)
Create mod(arg) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#multiply]\(arg)
Multiply with value{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#nullif]\(arg)
Create nullif(arg) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#plus]\(arg)
Add up value{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#substring]\(pos)
Create substring(pos) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#substring]\(pos, len)
Create substring(pos, len) expression{td}{tr}{tbody}{table}\\ 

{table:id=property|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Property Details{th}{tr}{tbody:id=abs}{tr:id=name}{td}h6.abs{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create abs(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.abs)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=asc}{tr:id=name}{td}h6.asc{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an ascending sort expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBSort]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.sort
.add(query.joins.orders_to_order_details.columns.quantity.asc)
.add(query.columns.companyid)
foundset.loadRecords(query)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=avg}{tr:id=name}{td}h6.avg{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an aggregate expression.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.avg.eq(1))
	foundset.loadRecords(query)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=bit_length}{tr:id=name}{td}h6.bit_length{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create bit\_length(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.bit_length)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=ceil}{tr:id=name}{td}h6.ceil{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create ceil(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.ceil)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=count}{tr:id=name}{td}h6.count{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an aggregate expression.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.eq(0))
	foundset.loadRecords(query)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=day}{tr:id=name}{td}h6.day{td}{tr}{tr:id=des}{td}{div:class=sIndent}Extract day from date{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mydatecol.day)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=desc}{tr:id=name}{td}h6.desc{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an descending sort expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBSort]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.sort
.add(query.joins.orders_to_order_details.columns.quantity.desc)
.add(query.columns.companyid)
foundset.loadRecords(query)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=floor}{tr:id=name}{td}h6.floor{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create floor(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.floor)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=hour}{tr:id=name}{td}h6.hour{td}{tr}{tr:id=des}{td}{div:class=sIndent}Extract hour from date{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mydatecol.hour)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isNull}{tr:id=name}{td}h6.isNull{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with null.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.isNull)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=len}{tr:id=name}{td}h6.len{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create length(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.len)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=lower}{tr:id=name}{td}h6.lower{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create lower(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.lower)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=max}{tr:id=name}{td}h6.max{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an aggregate expression.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.max(10))
	foundset.loadRecords(query)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=min}{tr:id=name}{td}h6.min{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an aggregate expression.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.min(10))
	foundset.loadRecords(query)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minute}{tr:id=name}{td}h6.minute{td}{tr}{tr:id=des}{td}{div:class=sIndent}Extract minute from date{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mydatecol.minute)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=month}{tr:id=name}{td}h6.month{td}{tr}{tr:id=des}{td}{div:class=sIndent}Extract month from date{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mydatecol.month)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=not}{tr:id=name}{td}h6.not{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create a negated condition.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBColumn]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.not.eq(1))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=parent}{tr:id=name}{td}h6.parent{td}{tr}{tr:id=des}{td}{div:class=sIndent}Get query builder parent table clause, this may be a query or a join clause.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBTableClause]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @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)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=root}{tr:id=name}{td}h6.root{td}{tr}{tr:id=des}{td}{div:class=sIndent}Get query builder parent.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBSelect]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @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)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=round}{tr:id=name}{td}h6.round{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create round(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.round)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=second}{tr:id=name}{td}h6.second{td}{tr}{tr:id=des}{td}{div:class=sIndent}Extract second from date{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mydatecol.second)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sqrt}{tr:id=name}{td}h6.sqrt{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create sqrt(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.sqrt)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sum}{tr:id=name}{td}h6.sum{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create an aggregate expression.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.sum(10))
	foundset.loadRecords(query)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=trim}{tr:id=name}{td}h6.trim{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create trim(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.trim)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=upper}{tr:id=name}{td}h6.upper{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create upper(column) expression{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.upper)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=year}{tr:id=name}{td}h6.year{td}{tr}{tr:id=des}{td}{div:class=sIndent}Extract year from date{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mydatecol.year)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ 

{table:id=function|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=between-Object_Object}{tr:id=name}{td}h6.between{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}between{span}{span}\(value1, value2){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column to a range of 2 values or other columns.{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value1
\{[Object]} value2
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.between(0, 5))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=cast-String}{tr:id=name}{td}h6.cast{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}cast{span}{span}\(type){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create cast(column, type) expression{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[String]} type -- string type, see QUERY\_COLUMN\_TYPES
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.cast(QUERY_COLUMN_TYPES.TYPE_INTEGER))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=concat-Object}{tr:id=name}{td}h6.concat{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}concat{span}{span}\(arg){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Concatename with value{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- valeu to concatenate with
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.firstname.concat(' ').concat(query.columns.lastname))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=divide-Object}{tr:id=name}{td}h6.divide{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}divide{span}{span}\(arg){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Divide by value{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- nr to divide by
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.divide(2))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=eq-Object}{tr:id=name}{td}h6.eq{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}eq{span}{span}\(value){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column.
Operator: equals{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.eq(1))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=ge-Object}{tr:id=name}{td}h6.ge{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}ge{span}{span}\(value){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column.
Operator: greaterThanOrEqual{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.ge(2))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=gt-Object}{tr:id=name}{td}h6.gt{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}gt{span}{span}\(value){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column.
Operator: greaterThan{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.gt(0))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isin-QBPart}{tr:id=name}{td}h6.isin{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}isin{span}{span}\(query){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with subquery result.{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[QBPart]} query -- subquery
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.isin(query2))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isin-ObjectArray}{tr:id=name}{td}h6.isin{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}isin{span}{span}\(values){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with values.{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]\[]} values -- array of values
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.isin([1, 5, 99]))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=le-Object}{tr:id=name}{td}h6.le{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}le{span}{span}\(value){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column.
Operator: lessThanOrEqual{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.le(2))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=like-String}{tr:id=name}{td}h6.like{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}like{span}{span}\(pattern){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column.
Operator: like{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[String]} pattern -- the string value of the pattern
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.where.add(query.columns.companyname.like('Serv%'))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=like-String_String}{tr:id=name}{td}h6.like{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}like{span}{span}\(pattern, escape){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column.
Operator: like, with escape character{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[String]} pattern -- the string value of the pattern
\{[String]} escape -- the escape char
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.where.add(query.columns.companyname.like('X_%', '_'))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locate-Object}{tr:id=name}{td}h6.locate{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}locate{span}{span}\(arg){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create locate(arg) expression{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- string to locate
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.locate('sample'))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locate-Object_Number}{tr:id=name}{td}h6.locate{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}locate{span}{span}\(arg, start){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create locate(arg, start) expression{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- string to locate
\{[Number]} start -- start pos
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.locate('sample', 5))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=lt-Object}{tr:id=name}{td}h6.lt{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}lt{span}{span}\(value){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Compare column with a value or another column.
Operator: lessThan{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.lt(99))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minus-Object}{tr:id=name}{td}h6.minus{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}minus{span}{span}\(arg){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Subtract value{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- nr to subtract
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.minus(2))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=mod-Object}{tr:id=name}{td}h6.mod{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}mod{span}{span}\(arg){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create mod(arg) expression{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- mod arg
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.mod(2))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=multiply-Object}{tr:id=name}{td}h6.multiply{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}multiply{span}{span}\(arg){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Multiply with value{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- nr to multiply with
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.multiply(2))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=nullif-Object}{tr:id=name}{td}h6.nullif{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}nullif{span}{span}\(arg){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create nullif(arg) expression{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- object to compare
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.nullif('none'))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=plus-Object}{tr:id=name}{td}h6.plus{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}plus{span}{span}\(arg){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Add up value{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- nr to add
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.plus(2))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=substring-Number}{tr:id=name}{td}h6.substring{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}substring{span}{span}\(pos){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create substring(pos) expression{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Number]} pos
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.substring(3))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=substring-Number_Number}{tr:id=name}{td}h6.substring{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}substring{span}{span}\(pos, len){span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Create substring(pos, len) expression{div}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Number]} pos
\{[Number]} len
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.substring(3, 2))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}