Child pages
  • QBFunction

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
{hiddendiv: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 EXTRACTAUTO CHANGES FROMUPDATE THE PAGECONTENT ANDTHROUGH MERGETHE THEM BACK INTO SERVOY SOURCE{hiddenDOC GENERATOR{div}
{sub-sectiondiv:id=description|text=}{sub-sectiondiv}\\ 

{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|class=node}{tr:id=name}{td}h6.abs{td}{tr}{builder-show:permission=edit}{tr:id=desret}{td}{sub-section:abs_des|trigger=button|text=}{sub-section}{sub-section:abs_des|trigger=none|*Returns*\\{div:class=sIndent}Replace with description{sub-section[QBFunction]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:abs_snc|trigger=button|text=}{sub-section}{sub-section:abs_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.abs)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-showtbody}{builder-showtbody:permissionid=editasc}{tr:id=prs}name}{td}h6.asc{td}*Parameters*\\{sub-section:abs_prs|trigger=button|text=}{sub-section}{sub-section:abs_prs|trigger=none|{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section[QBSort]{div}{td}{tr}{builder-show}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:abs_ret|trigger=button|text=}{sub-section}{sub-section:abs_ret|trigger=none|class=sIndent}[QBFunction]{sub-sectiondiv: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}{builder-showtbody:permissionid=editavg}{tr:id=see}name}{td}h6.avg{td}*Also see*\\{sub-section:abs_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:abs_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link{tr}{tr:id=ret}{td}*External linksReturns*\\{sub-section:abs_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:abs_link|trigger=none}{sub-section}{[QBAggregate]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:abs_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:abs_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.custname.abs)
{code}{sub-section/** @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=asc|class=nodebit_length}{tr:id=name}{td}h6.ascbit_length{td}{tr}{builder-show:permission=edit}{tr:id=desret}{td}{sub-section:asc_des|trigger=button|text=}{sub-section}{sub-section:asc_des|trigger=none|class=sIndent}Replace with description{sub-section*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:asc_snc|trigger=button|text=}{sub-section}{sub-section:asc_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.bit_length)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-showtbody}{builder-showtbody:permissionid=editceil}{tr:id=prsname}{td}*Parameters*\\{sub-section:asc_prs|trigger=button|text=}{sub-section}{sub-section:asc_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-showh6.ceil{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:asc_ret|trigger=button|text=}{sub-section}{sub-section:asc_ret|trigger=none|div:class=sIndent}[QBSortQBFunction]{sub-sectiondiv}{td}{tr}{builder-show:permission=edit}{tr:id=seesam}{td}*Also seeSample*\\{sub-section:asc_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:asc_see|trigger=none}{sub-sectioncode:language=javascript}
query.result.add(query.columns.mycol.ceil)
{code}{div}{td}{tr}{builder-show}{builder-show:permission=edittr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=count}{tr:id=link}name}{td}h6.count{td}*External links*\\{sub-section:asc_link|trigger=button|text=}{sub-section}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section:asc_link|trigger=none}{sub-section}{[QBAggregate]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:asc_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:asc_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.sort
groupBy.add(query.joins.orders_to_order_details.columns.quantity.asc)
.add(query.columns.companyid)
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}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=avg|class=nodeday}{tr:id=name}{td}h6.avgday{td}{tr}{builder-show:permission=edit}{tr:id=desret}{td}{sub-section:avg_des|trigger=button|text=}{sub-section}{sub-section:avg_des|trigger=none|*Returns*\\{div:class=sIndent}Replace with description{sub-section[QBFunction]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:avg_snc|trigger=button|text=}{sub-section}{sub-section:avg_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mydatecol.day)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-showtbody}{builder-showtbody:permissionid=editdesc}{tr:id=prs}name}{td}h6.desc{td}*Parameters*\\{sub-section:avg_prs|trigger=button|text=}{sub-section}{sub-section:avg_prs|trigger=none|{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section[QBSort]{div}{td}{tr}{builder-show}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:avg_ret|trigger=button|text=}{sub-section}{sub-section:avg_ret|trigger=none|class=sIndent}[QBAggregate]{sub-sectiondiv: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}{builder-show:permission=edittbody}{tbody:id=floor}{tr:id=seename}{td}*Also see*\\{sub-section:avg_see|trigger=button|text=}{sub-section}h6.floor{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section:avg_see|trigger=none}{sub-section}{[QBFunction]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linksam}{td}*External linksSample*\\{sub-section:avg_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:avg_link|trigger=none}{sub-sectioncode:language=javascript}
query.result.add(query.columns.mycol.floor)
{code}{div}{td}{tr}{builder-show}{tr:idclass=samlastDetailRow}{td}*Sample*\\{sub-section:avg_sam|trigger=button|text=}{sub-section}{{td}{tr}{tbody}{tbody:id=hour}{tr:id=name}{td}h6.hour{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{sub-section:avg_sam|trigger=nonetr: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}{sub-section}{div}{td}{tr}{trquery.result.add(query.columns.mydatecol.hour)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=bit_length|class=nodeisNull}{tr:id=name}{td}h6.bit_lengthisNull{td}{tr}{builder-show:permission=edit}{tr:id=desret}{td}{sub-section:bit_length_des|trigger=button|text=}{sub-section}{sub-section:bit_length_des|trigger=none|*Returns*\\{div:class=sIndent}Replace with description{sub-section[QBCondition]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{trtr:id=sncsam}{td}*SinceSample*\\{sub-section:bit_length_snc|trigger=button|text=}{sub-section}{sub-section:bit_length_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.isNull)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-show}{builder-show:permission=edittbody}{tbody:id=len}{tr:id=name}{td}h6.len{td}{tr}{tr:id=prsret}{td}*ParametersReturns*\\{sub-section:bit_length_prs|trigger=button|text=}{sub-section}{sub-section:bit_length_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-showdiv:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:bit_length_ret|trigger=button|text=}{sub-section}{sub-section:bit_length_ret|trigger=none|class=sIndent}[QBFunction]{sub-sectiondiv: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}{builder-showtr:permission=editid=name}{td}h6.lower{td}{tr}{tr:id=seeret}{td}*Also seeReturns*\\{sub-section:bit_length_see|trigger=button|text=}{sub-section}div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{sub-section:bit_length_see|trigger=none}{sub-sectioncode:language=javascript}
query.result.add(query.columns.custname.lower)
{code}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linktr:class=lastDetailRow}{td}{td}*External links*\\{sub-section:bit_length_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:bit_length_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show{tr}{tbody}{tbody:id=max}{tr:id=name}{td}h6.max{td}{tr}{tr:id=samret}{td}*SampleReturns*\\{sub-section:bit_length_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:bit_length_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.custname.bit_length)
{code}{sub-section}{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:classid=lastDetailRowsam}{td}{td}{tr}{tbody}{tbody:id=ceil|class=node}{tr:id=name}{td}h6.ceil{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:ceil_des|trigger=button|text=}{sub-section}{sub-section:ceil_des|trigger=none|class=sIndent}Replace with description{sub-section*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}{builder-showtbody}{builder-showtbody:permissionid=editmin}{tr:id=sncname}{td}*Since*\\{sub-section:ceil_snc|trigger=button|text=}{sub-section}{sub-section:ceil_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{h6.min{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prsret}{td}*ParametersReturns*\\{sub-section:ceil_prs|trigger=button|text=}{sub-section}{sub-section:ceil_prs|trigger=none|div:class=sIndent}{sub-section[QBAggregate]{div}{td}{tr}{builder-show}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:ceil_ret|trigger=button|text=}{sub-section}{sub-section:ceil_ret|trigger=none|class=sIndent}[QBFunction]{sub-sectiondiv: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}{builder-show:permission=edittbody}{tbody:id=minute}{tr:id=seename}{td}*Also see*\\{sub-section:ceil_see|trigger=button|text=}{sub-section}h6.minute{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section:ceil_see|trigger=none}{sub-section}{[QBFunction]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linksam}{td}*External linksSample*\\{sub-section:ceil_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ceil_link|trigger=none}{sub-sectioncode:language=javascript}
query.result.add(query.columns.mydatecol.minute)
{code}{div}{td}{tr}{builder-show}{tr:id=samclass=lastDetailRow}{td}{td}*Sample*\\{sub-section:ceil_sam|trigger=button|text=}{sub-section}{tr}{tbody}{tbody:id=month}{tr:id=name}{td}h6.month{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section:ceil_sam|trigger=none}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycolmydatecol.ceilmonth)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=count|class=nodenot}{tr:id=name}{td}h6.countnot{td}{tr}{builder-show:permission=edit}{tr:id=desret}{td}{sub-section:count_des|trigger=button|text=}{sub-section}{sub-section:count_des|trigger=none|class=sIndent}Replace with description{sub-section*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}{builder-show}{builder-show:permission=edit}{tr:id=snctr:class=lastDetailRow}{td}{td}*Since*\\{sub-section:count_snc|trigger=button|text=}{sub-section}{sub-section:count_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{tr}{tbody}{tbody:id=parent}{tr:id=name}{td}h6.parent{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prsret}{td}*ParametersReturns*\\{sub-section:count_prs|trigger=button|text=}{sub-section}{sub-section:count_prs|trigger=none|class=sIndent}{sub-sectiondiv:class=sIndent}[QBTableClause]{div}{td}{tr}{builder-show}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:count_ret|trigger=button|text=}{sub-section}{sub-section:count_ret|trigger=none|div:class=sIndent}[QBAggregate]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:count_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:count_see|trigger=none}{sub-section}{div}{{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}{builder-showtbody}{builder-showtbody:permissionid=editroot}{tr:id=linkname}{td}*External links*\\{sub-section:count_link|trigger=button|text=}{sub-section}h6.root{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section:count_link|trigger=none}{sub-section}{[QBSelect]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:count_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:count_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>order_details>} */
	var querysubquery = databaseManager.createSelect('db:/example_data/ordersorder_details')
	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.@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}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=day|class=node}{tr:id=name}{td}h6.day{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:day_des|trigger=button|text=}{sub-section}{sub-section:day_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:day_snc|trigger=button|text=}{sub-section}{sub-section:day_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:day_prs|trigger=button|text=}{sub-section}{sub-section:day_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:day_ret|trigger=button|text=}{sub-section}{sub-section:day_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:day_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:day_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:day_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:day_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:day_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:day_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mydatecol.day)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=desc|class=node}{tr:id=name}{td}h6.desc{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:desc_des|trigger=button|text=}{sub-section}{sub-section:desc_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:desc_snc|trigger=button|text=}{sub-section}{sub-section:desc_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:desc_prs|trigger=button|text=}{sub-section}{sub-section:desc_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:desc_ret|trigger=button|text=}{sub-section}{sub-section:desc_ret|trigger=none|class=sIndent}[QBSort]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:desc_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:desc_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:desc_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:desc_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:desc_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:desc_sam|trigger=none}{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}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=floor|class=node}{tr:id=name}{td}h6.floor{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:floor_des|trigger=button|text=}{sub-section}{sub-section:floor_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:floor_snc|trigger=button|text=}{sub-section}{sub-section:floor_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:floor_prs|trigger=button|text=}{sub-section}{sub-section:floor_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:floor_ret|trigger=button|text=}{sub-section}{sub-section:floor_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:floor_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:floor_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:floor_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:floor_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:floor_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:floor_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycol.floor)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=hour|class=node}{tr:id=name}{td}h6.hour{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:hour_des|trigger=button|text=}{sub-section}{sub-section:hour_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:hour_snc|trigger=button|text=}{sub-section}{sub-section:hour_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:hour_prs|trigger=button|text=}{sub-section}{sub-section:hour_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:hour_ret|trigger=button|text=}{sub-section}{sub-section:hour_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:hour_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:hour_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:hour_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:hour_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:hour_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:hour_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mydatecol.hour)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isNull|class=node}{tr:id=name}{td}h6.isNull{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:isNull_des|trigger=button|text=}{sub-section}{sub-section:isNull_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:isNull_snc|trigger=button|text=}{sub-section}{sub-section:isNull_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:isNull_prs|trigger=button|text=}{sub-section}{sub-section:isNull_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:isNull_ret|trigger=button|text=}{sub-section}{sub-section:isNull_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:isNull_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isNull_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:isNull_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isNull_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:isNull_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isNull_sam|trigger=none}{code:language=javascript}
query.where.add(query.columns.flag.isNull)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=len|class=node}{tr:id=name}{td}h6.len{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:len_des|trigger=button|text=}{sub-section}{sub-section:len_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:len_snc|trigger=button|text=}{sub-section}{sub-section:len_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:len_prs|trigger=button|text=}{sub-section}{sub-section:len_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:len_ret|trigger=button|text=}{sub-section}{sub-section:len_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:len_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:len_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:len_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:len_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:len_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:len_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.custname.len)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=lower|class=node}{tr:id=name}{td}h6.lower{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:lower_des|trigger=button|text=}{sub-section}{sub-section:lower_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:lower_snc|trigger=button|text=}{sub-section}{sub-section:lower_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:lower_prs|trigger=button|text=}{sub-section}{sub-section:lower_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:lower_ret|trigger=button|text=}{sub-section}{sub-section:lower_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:lower_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lower_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:lower_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lower_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:lower_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lower_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.custname.lower)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=max|class=node}{tr:id=name}{td}h6.max{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:max_des|trigger=button|text=}{sub-section}{sub-section:max_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:max_snc|trigger=button|text=}{sub-section}{sub-section:max_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:max_prs|trigger=button|text=}{sub-section}{sub-section:max_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:max_ret|trigger=button|text=}{sub-section}{sub-section:max_ret|trigger=none|class=sIndent}[QBAggregate]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:max_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:max_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:max_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:max_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:max_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:max_sam|trigger=none}{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}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=min|class=node}{tr:id=name}{td}h6.min{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:min_des|trigger=button|text=}{sub-section}{sub-section:min_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:min_snc|trigger=button|text=}{sub-section}{sub-section:min_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:min_prs|trigger=button|text=}{sub-section}{sub-section:min_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:min_ret|trigger=button|text=}{sub-section}{sub-section:min_ret|trigger=none|class=sIndent}[QBAggregate]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:min_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:min_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:min_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:min_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:min_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:min_sam|trigger=none}{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}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minute|class=node}{tr:id=name}{td}h6.minute{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:minute_des|trigger=button|text=}{sub-section}{sub-section:minute_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:minute_snc|trigger=button|text=}{sub-section}{sub-section:minute_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:minute_prs|trigger=button|text=}{sub-section}{sub-section:minute_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:minute_ret|trigger=button|text=}{sub-section}{sub-section:minute_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:minute_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minute_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:minute_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minute_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:minute_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minute_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mydatecol.minute)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=month|class=node}{tr:id=name}{td}h6.month{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:month_des|trigger=button|text=}{sub-section}{sub-section:month_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:month_snc|trigger=button|text=}{sub-section}{sub-section:month_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:month_prs|trigger=button|text=}{sub-section}{sub-section:month_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:month_ret|trigger=button|text=}{sub-section}{sub-section:month_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:month_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:month_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:month_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:month_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:month_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:month_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mydatecol.month)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=not|class=node}{tr:id=name}{td}h6.not{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:not_des|trigger=button|text=}{sub-section}{sub-section:not_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:not_snc|trigger=button|text=}{sub-section}{sub-section:not_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:not_prs|trigger=button|text=}{sub-section}{sub-section:not_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:not_ret|trigger=button|text=}{sub-section}{sub-section:not_ret|trigger=none|class=sIndent}[QBColumn]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:not_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:not_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:not_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:not_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:not_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:not_sam|trigger=none}{code:language=javascript}
query.where.add(query.columns.flag.not.eq(1))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=parent|class=node}{tr:id=name}{td}h6.parent{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:parent_des|trigger=button|text=}{sub-section}{sub-section:parent_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:parent_snc|trigger=button|text=}{sub-section}{sub-section:parent_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:parent_prs|trigger=button|text=}{sub-section}{sub-section:parent_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:parent_ret|trigger=button|text=}{sub-section}{sub-section:parent_ret|trigger=none|class=sIndent}[QBTableClause]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:parent_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:parent_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:parent_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:parent_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:parent_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:parent_sam|trigger=none}{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}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=root|class=node}{tr:id=name}{td}h6.root{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:root_des|trigger=button|text=}{sub-section}{sub-section:root_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:root_snc|trigger=button|text=}{sub-section}{sub-section:root_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:root_prs|trigger=button|text=}{sub-section}{sub-section:root_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:root_ret|trigger=button|text=}{sub-section}{sub-section:root_ret|trigger=none|class=sIndent}[QBSelect]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:root_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:root_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:root_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:root_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:root_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:root_sam|trigger=none}{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}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=round|class=node}{tr:id=name}{td}h6.round{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:round_des|trigger=button|text=}{sub-section}{sub-section:round_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:round_snc|trigger=button|text=}{sub-section}{sub-section:round_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:round_prs|trigger=button|text=}{sub-section}{sub-section:round_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:round_ret|trigger=button|text=}{sub-section}{sub-section:round_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:round_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:round_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:round_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:round_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:round_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:round_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycol.round)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=second|class=node}{tr:id=name}{td}h6.second{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:second_des|trigger=button|text=}{sub-section}{sub-section:second_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:second_snc|trigger=button|text=}{sub-section}{sub-section:second_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:second_prs|trigger=button|text=}{sub-section}{sub-section:second_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:second_ret|trigger=button|text=}{sub-section}{sub-section:second_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:second_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:second_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:second_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:second_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:second_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:second_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mydatecol.second)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sqrt|class=node}{tr:id=name}{td}h6.sqrt{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:sqrt_des|trigger=button|text=}{sub-section}{sub-section:sqrt_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:sqrt_snc|trigger=button|text=}{sub-section}{sub-section:sqrt_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:sqrt_prs|trigger=button|text=}{sub-section}{sub-section:sqrt_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:sqrt_ret|trigger=button|text=}{sub-section}{sub-section:sqrt_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:sqrt_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sqrt_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:sqrt_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sqrt_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:sqrt_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sqrt_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.custname.sqrt)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sum|class=node}{tr:id=name}{td}h6.sum{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:sum_des|trigger=button|text=}{sub-section}{sub-section:sum_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:sum_snc|trigger=button|text=}{sub-section}{sub-section:sum_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:sum_prs|trigger=button|text=}{sub-section}{sub-section:sum_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:sum_ret|trigger=button|text=}{sub-section}{sub-section:sum_ret|trigger=none|class=sIndent}[QBAggregate]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:sum_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sum_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:sum_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sum_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:sum_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sum_sam|trigger=none}{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}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=trim|class=node}{tr:id=name}{td}h6.trim{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:trim_des|trigger=button|text=}{sub-section}{sub-section:trim_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:trim_snc|trigger=button|text=}{sub-section}{sub-section:trim_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:trim_prs|trigger=button|text=}{sub-section}{sub-section:trim_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:trim_ret|trigger=button|text=}{sub-section}{sub-section:trim_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:trim_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:trim_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:trim_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:trim_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:trim_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:trim_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.custname.trim)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=upper|class=node}{tr:id=name}{td}h6.upper{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:upper_des|trigger=button|text=}{sub-section}{sub-section:upper_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:upper_snc|trigger=button|text=}{sub-section}{sub-section:upper_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:upper_prs|trigger=button|text=}{sub-section}{sub-section:upper_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:upper_ret|trigger=button|text=}{sub-section}{sub-section:upper_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:upper_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:upper_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:upper_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:upper_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:upper_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:upper_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.custname.upper)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=year|class=node}{tr:id=name}{td}h6.year{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:year_des|trigger=button|text=}{sub-section}{sub-section:year_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:year_snc|trigger=button|text=}{sub-section}{sub-section:year_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:year_prs|trigger=button|text=}{sub-section}{sub-section:year_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:year_ret|trigger=button|text=}{sub-section}{sub-section:year_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:year_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:year_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:year_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:year_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:year_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:year_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mydatecol.year)
{code}{sub-section}{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|class=node}{tr:id=name}{td}h6.between{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}between{span}{span:id=iets|style=float: left;}\(value1, value2){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:between-Object_Object_des|trigger=button|text=}{sub-section}{sub-section:between-Object_Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:between-Object_Object_snc|trigger=button|text=}{sub-section}{sub-section:between-Object_Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:between-Object_Object_prs|trigger=button|text=}{sub-section}{sub-section:between-Object_Object_prs|trigger=none|class=sIndent}\{[Object]} value1
\{[Object]} value2
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:between-Object_Object_ret|trigger=button|text=}{sub-section}{sub-section:between-Object_Object_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:between-Object_Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:between-Object_Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:between-Object_Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:between-Object_Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:between-Object_Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:between-Object_Object_sam|trigger=none}{code:language=javascript}
query.where.add(query.columns.flag.between(0, 5))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=cast-String|class=node}{tr:id=name}{td}h6.cast{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}cast{span}{span:id=iets|style=float: left;}\(type){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:cast-String_des|trigger=button|text=}{sub-section}{sub-section:cast-String_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:cast-String_snc|trigger=button|text=}{sub-section}{sub-section:cast-String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:cast-String_prs|trigger=button|text=}{sub-section}{sub-section:cast-String_prs|trigger=none|class=sIndent}\{[String]} type -- string type, see QUERY\_COLUMN\_TYPES
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:cast-String_ret|trigger=button|text=}{sub-section}{sub-section:cast-String_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:cast-String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:cast-String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:cast-String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:cast-String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:cast-String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:cast-String_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycol.cast(QUERY_COLUMN_TYPES.TYPE_INTEGER))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=concat-Object|class=node}{tr:id=name}{td}h6.concat{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}concat{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:concat-Object_des|trigger=button|text=}{sub-section}{sub-section:concat-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:concat-Object_snc|trigger=button|text=}{sub-section}{sub-section:concat-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:concat-Object_prs|trigger=button|text=}{sub-section}{sub-section:concat-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- valeu to concatenate with
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:concat-Object_ret|trigger=button|text=}{sub-section}{sub-section:concat-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:concat-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:concat-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:concat-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:concat-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:concat-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:concat-Object_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.firstname.concat(' ').concat(query.columns.lastname))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=divide-Object|class=node}{tr:id=name}{td}h6.divide{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}divide{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:divide-Object_des|trigger=button|text=}{sub-section}{sub-section:divide-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:divide-Object_snc|trigger=button|text=}{sub-section}{sub-section:divide-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:divide-Object_prs|trigger=button|text=}{sub-section}{sub-section:divide-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- nr to divide by
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:divide-Object_ret|trigger=button|text=}{sub-section}{sub-section:divide-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:divide-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:divide-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:divide-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:divide-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:divide-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:divide-Object_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycol.divide(2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=eq-Object|class=node}{tr:id=name}{td}h6.eq{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}eq{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:eq-Object_des|trigger=button|text=}{sub-section}{sub-section:eq-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:eq-Object_snc|trigger=button|text=}{sub-section}{sub-section:eq-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:eq-Object_prs|trigger=button|text=}{sub-section}{sub-section:eq-Object_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:eq-Object_ret|trigger=button|text=}{sub-section}{sub-section:eq-Object_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:eq-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:eq-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:eq-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:eq-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:eq-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:eq-Object_sam|trigger=none}{code:language=javascript}
query.where.add(query.columns.flag.eq(1))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=ge-Object|class=node}{tr:id=name}{td}h6.ge{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}ge{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:ge-Object_des|trigger=button|text=}{sub-section}{sub-section:ge-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:ge-Object_snc|trigger=button|text=}{sub-section}{sub-section:ge-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:ge-Object_prs|trigger=button|text=}{sub-section}{sub-section:ge-Object_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:ge-Object_ret|trigger=button|text=}{sub-section}{sub-section:ge-Object_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:ge-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ge-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:ge-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ge-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:ge-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ge-Object_sam|trigger=none}{code:language=javascript}
query.where.add(query.columns.flag.ge(2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=gt-Object|class=node}{tr:id=name}{td}h6.gt{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}gt{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:gt-Object_des|trigger=button|text=}{sub-section}{sub-section:gt-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:gt-Object_snc|trigger=button|text=}{sub-section}{sub-section:gt-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:gt-Object_prs|trigger=button|text=}{sub-section}{sub-section:gt-Object_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:gt-Object_ret|trigger=button|text=}{sub-section}{sub-section:gt-Object_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:gt-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:gt-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:gt-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:gt-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:gt-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:gt-Object_sam|trigger=none}{code:language=javascript}
query.where.add(query.columns.flag.gt(0))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isin-QBPart|class=node}{tr:id=name}{td}h6.isin{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}isin{span}{span:id=iets|style=float: left;}\(query){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:isin-QBPart_des|trigger=button|text=}{sub-section}{sub-section:isin-QBPart_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:isin-QBPart_snc|trigger=button|text=}{sub-section}{sub-section:isin-QBPart_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:isin-QBPart_prs|trigger=button|text=}{sub-section}{sub-section:isin-QBPart_prs|trigger=none|class=sIndent}\{[QBPart]} query -- subquery
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:isin-QBPart_ret|trigger=button|text=}{sub-section}{sub-section:isin-QBPart_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:isin-QBPart_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isin-QBPart_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:isin-QBPart_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isin-QBPart_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:isin-QBPart_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isin-QBPart_sam|trigger=none}{code:language=javascript}
query.where.add(query.columns.flag.isin(query2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isin-ObjectArray|class=node}{tr:id=name}{td}h6.isin{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}isin{span}{span:id=iets|style=float: left;}\(values){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:isin-ObjectArray_des|trigger=button|text=}{sub-section}{sub-section:isin-ObjectArray_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:isin-ObjectArray_snc|trigger=button|text=}{sub-section}{sub-section:isin-ObjectArray_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:isin-ObjectArray_prs|trigger=button|text=}{sub-section}{sub-section:isin-ObjectArray_prs|trigger=none|class=sIndent}\{[Object]\[]} values -- array of values
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:isin-ObjectArray_ret|trigger=button|text=}{sub-section}{sub-section:isin-ObjectArray_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:isin-ObjectArray_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isin-ObjectArray_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:isin-ObjectArray_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isin-ObjectArray_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:isin-ObjectArray_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isin-ObjectArray_sam|trigger=none}{code:language=javascript}
query.where.add(query.columns.flag.isin([1, 5, 99]))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=le-Object|class=node}{tr:id=name}{td}h6.le{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}le{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:le-Object_des|trigger=button|text=}{sub-section}{sub-section:le-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:le-Object_snc|trigger=button|text=}{sub-section}{sub-section:le-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:le-Object_prs|trigger=button|text=}{sub-section}{sub-section:le-Object_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}}{tbody}{tbody:id=round}{tr:id=name}{td}h6.round{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:le-Object_ret|trigger=button|text=}{sub-section}{sub-section:le-Object_ret|trigger=none|div:class=sIndent}[QBConditionQBFunction]{sub-sectiondiv}{td}{tr}{builder-show:permission=edit}{tr:id=seesam}{td}*Also seeSample*\\{sub-section:le-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:le-Object_see|trigger=none}{sub-section}{divdiv:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.round)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-showtbody}{builder-showtbody:permissionid=editsecond}{tr:id=link}name}{td}h6.second{td}*External links*\\{sub-section:le-Object_link|trigger=button|text=}{sub-section}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section:le-Object_link|trigger=none}{sub-section}{[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:le-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:le-Object_sam|trigger=none}{code:language=javascript}
query.whereresult.add(query.columns.flagmydatecol.le(2second))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=like-String|class=node=sqrt}{tr:id=name}{td}h6.likesqrt{td}{tr}{tr:id=sigret}{td}*Returns*\\{spandiv:style=float: left; margin-right: 5px;}[QBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}like{span}{span:id=iets|style=float: left;}\(pattern){span}{td}{tr}{builder-show:permission=editclass=sIndent}[QBFunction]{div}{td}{tr}{tr:id=dessam}{td}{sub-section:like-String_des|trigger=button|text=}{sub-section}{sub-section:like-String_des|trigger=none|class=sIndent}Replace with description{sub-section*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.sqrt)
{code}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snctr:class=lastDetailRow}{td}{td}*Since*\\{sub-section:like-String_snc|trigger=button|text=}{sub-section}{sub-section:like-String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{tr}{tbody}{tbody:id=sum}{tr:id=name}{td}h6.sum{td}{tr}{builder-show}{tr:id=prsret}{td}*ParametersReturns*\\{sub-section:like-String_prs|trigger=button|text=}{sub-section}{sub-section:like-String_prs|trigger=none|div:class=sIndent}\{[String]} pattern -- the string value of the pattern
{sub-section[QBAggregate]{div}{td}{tr}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:like-String_ret|trigger=button|text=}{sub-section}{sub-section:like-String_ret|trigger=none|class=sIndent}[QBCondition]{sub-sectiondiv: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}{builder-show:permission=edit}{tr:idclass=seelastDetailRow}{td}*Also see*\\{sub-section:like-String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:like-String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-showtbody}{builder-showtbody:permissionid=edittrim}{tr:id=linkname}{td}*External links*\\{sub-section:like-String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:like-String_link|trigger=none}{sub-section}h6.trim{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:like-String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:like-String_sam|trigger=none}{code:language=javascript}
query.whereresult.add(query.columns.companyname.like('Serv%'))custname.trim)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=like-String_String|class=nodeupper}{tr:id=name}{td}h6.likeupper{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sigsam}{td}*Sample*\\{spandiv:style=float: left; margin-right: 5px;}[QBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}like{span}{span:id=iets|style=float: left;}\(pattern, escape){spanclass=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.upper)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-show:permission=edittbody}{tbody:id=year}{tr:id=des}name}{td}h6.year{td}{sub-section:like-String_String_des|trigger=button|text=}{sub-section}{sub-section:like-String_String_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edittr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:like-String_String_snc|trigger=button|text=}{sub-section}{sub-section:like-String_String_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mydatecol.year)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-showtbody}{trtable}\\ 

{table:id=prsfunction|class=servoy sDetail}{tdcolgroup}*Parameters*\\{sub-section:like-String_String_prs|trigger=button|text=}{sub-section}{sub-section:like-String_String_prs|trigger=none|class=sIndent}\{[String]} pattern -- the string value of the pattern
\{[String]} escape -- the escape char
{sub-section}{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=retsig}{td}*Returns*\\{sub-section:like-String_String_ret|trigger=button|text=}{sub-section}{sub-section:like-String_String_ret|trigger=none|class=sIndent}[QBCondition]{sub-section{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}between{span}{span}\(value1, value2){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:like-String_String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:like-String_String_see|trigger=none}{sub-section}\{[Object]} value1
\{[Object]} value2
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:like-String_String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:like-String_String_link|trigger=none}{sub-section}}[QBCondition]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:like-String_String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:like-String_String_sam|trigger=none}{code:language=javascript}
query.where.add(query.columns.companynameflag.like('X_%'between(0, '_'5))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locate-Object|class=nodecast-String}{tr:id=name}{td}h6.locatecast{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}locatecast{span}{span}\(type){span}{td}{tr}{tr:id=iets|style=float: left;}\(arg){spanprs}{td}*Parameters*\\{div:class=sIndent}\{[String]} type -- string type, see QUERY\_COLUMN\_TYPES
{div}{td}{tr}{builder-show:permission=edit}{tr:id=desret}{td}{sub-section:locate-Object_des|trigger=button|text=}{sub-section}{sub-section:locate-Object_des|trigger=none|*Returns*\\{div:class=sIndent}Replace with description{sub-section[QBFunction]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:locate-Object_snc|trigger=button|text=}{sub-section}{sub-section:locate-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.cast(QUERY_COLUMN_TYPES.TYPE_INTEGER))
{code}{div}{td}{tr}{builder-show}{tr:id=prsclass=lastDetailRow}{td}{td}*Parameters*\\{sub-section:locate-Object_prs|trigger=button|text=}{sub-section}{sub-section:locate-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- string to locate
{sub-section}{tr}{tbody}{tbody:id=concat-Object}{tr:id=name}{td}h6.concat{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:locate-Object_ret|trigger=button|text=}{sub-section}{sub-section:locate-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}concat{span}{span}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:locate-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_see|trigger=none}{sub-section}\{[Object]} arg -- valeu to concatenate with
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:locate-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_link|trigger=none}{sub-section}{div:class=sIndent}[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:locate-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycolfirstname.locateconcat('sample ').concat(query.columns.lastname))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locatedivide-Object_Number|class=node}{tr:id=name}{td}h6.locatedivide{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}locatedivide{span}{span}\(arg){span}{td}{tr}{tr:id=iets|style=float: left;}\(arg, start){spanprs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- nr to divide by
{div}{td}{tr}{tr:id=ret}{td}{builder-show:permission=edit*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=dessam}{td}{sub-section:locate-Object_Number_des|trigger=button|text=}{sub-section}{sub-section:locate-Object_Number_des|trigger=none|class=sIndent}Replace with description{sub-section*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}{builder-showtbody:id=eq-Object}{builder-show:permission=edittr:id=name}{td}h6.eq{td}{tr}{tr:id=sncsig}{td}*Since*\\{sub-section:locate-Object_Number_snc|trigger=button|text=}{sub-section}{sub-section:locate-Object_Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}eq{span}{span}\(value){span}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:locate-Object_Number_prs|trigger=button|text=}{sub-section}{sub-section:locate-Object_Number_prs|trigger=none|class=sIndent}\{[Object]} arg -- string to locate
\{[Number]} start -- start pos
{sub-sectiondiv:class=sIndent}\{[Object]} value
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:locate-Object_Number_ret|trigger=button|text=}{sub-section}{sub-section:locate-Object_Number_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=editdiv: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=seesig}{td}*Also see*\\{sub-section:locate-Object_Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Number_see|trigger=none}{sub-section}{div{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}ge{span}{span}\(value){span}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkprs}{td}*External linksParameters*\\{sub-section:locate-Object_Number_link|trigger=button|text=}{sub-section}div:class=sIndent}\{[Object]} value
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section:locate-Object_Number_link|trigger=none}{sub-section}[QBCondition]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:locate-Object_Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Number_sam|trigger=none}{code:language=javascript}
query.resultwhere.add(query.columns.mycolflag.locate('sample', 5ge(2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=ltgt-Object|class=node}{tr:id=name}{td}h6.ltgt{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}gt{span}lt{span}\(value){span}{td}{tr}{tr:id=iets|style=float: left;}\(value){spanprs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value
{div}{td}{tr}{builder-show:permission=edit}{tr:id=desret}{td}{sub-section:lt-Object_des|trigger=button|text=}{sub-section}{sub-section:lt-Object_des|trigger=none|*Returns*\\{div:class=sIndent}Replace with description{sub-section[QBCondition]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:lt-Object_snc|trigger=button|text=}{sub-section}{sub-section:lt-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.gt(0))
{code}{div}{td}{tr}{builder-show}{tr:id=prsclass=lastDetailRow}{td}{td}*Parameters*\\{sub-section:lt-Object_prs|trigger=button|text=}{sub-section}{sub-section:lt-Object_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{tr}{tbody}{tbody:id=isin-QBPart}{tr:id=name}{td}h6.isin{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:lt-Object_ret|trigger=button|text=}{sub-section}{sub-section:lt-Object_ret|trigger=none|class=sIndent}[QBCondition]{sub-section{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}isin{span}{span}\(query){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:lt-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lt-Object_see|trigger=none}{sub-section}\{[QBPart]} query -- subquery
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:lt-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lt-Object_link|trigger=none}{sub-section}{[QBCondition]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:lt-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lt-Object_sam|trigger=none}{code:language=javascript}
query.where.add(query.columns.flag.ltisin(99query2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minus-Object|class=nodeisin-ObjectArray}{tr:id=name}{td}h6.minusisin{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunctionQBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}minusisin{span}{span:id=iets|style=float: left;}\(argvalues){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:minus-Object_des|trigger=button|text=}{sub-section}{sub-section:minus-Object_des|trigger=none|class=sIndent}Replace with description{sub-section*Parameters*\\{div:class=sIndent}\{[Object]\[]} values -- array of values
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncret}{td}*SinceReturns*\\{sub-section:minus-Object_snc|trigger=button|text=}{sub-section}{sub-section:minus-Object_snc|trigger=none|div:class=sIndent} Replace with version info{sub-section[QBCondition]{div}{td}{tr}{builder-show}{tr:id=prssam}{td}*ParametersSample*\\{sub-section:minus-Object_prs|trigger=button|text=}{sub-section}{sub-section:minus-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- nr to subtract
{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.where.add(query.columns.flag.isin([1, 5, 99]))
{code}{div}{td}{tr}{tr:id=retclass=lastDetailRow}{td}{td}*Returns*\\{sub-section:minus-Object_ret|trigger=button|text=}{sub-section}{sub-section:minus-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{tr}{tbody}{tbody:id=le-Object}{tr:id=name}{td}h6.le{td}{tr}{builder-showtr:permission=editid=sig}{td}{trspan:id=see}{td}*Also see*\\{sub-section:minus-Object_see|trigger=button|text=}{sub-section}style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}le{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}{sub-section:minus-Object_see|trigger=none}{sub-section}\{[Object]} value
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:minus-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minus-Object_link|trigger=none}{sub-section}{[QBCondition]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:minus-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minus-Object_sam|trigger=none}{code:language=javascript}
query.resultwhere.add(query.columns.mycolflag.minusle(2))
{code}{sub-section{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=mod-Object|class=nodelike-String}{tr:id=name}{td}h6.modlike{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunctionQBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}modlike{span}{span:id=iets|style=float: left;}\(argpattern){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:mod-Object_des|trigger=button|text=}{sub-section}{sub-section:mod-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit*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=sncsam}{td}*SinceSample*\\{sub-section:mod-Object_snc|trigger=button|text=}{sub-section}{sub-section:mod-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.where.add(query.columns.companyname.like('Serv%'))
{code}{div}{td}{tr}{builder-show}{tr:id=prsclass=lastDetailRow}{td}{td}*Parameters*\\{sub-section:mod-Object_prs|trigger=button|text=}{sub-section}{sub-section:mod-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- mod arg
{sub-section}{tr}{tbody}{tbody:id=like-String_String}{tr:id=name}{td}h6.like{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:mod-Object_ret|trigger=button|text=}{sub-section}{sub-section:mod-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}like{span}{span}\(pattern, escape){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:mod-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:mod-Object_see|trigger=none}{sub-section}div:class=sIndent}\{[String]} pattern -- the string value of the pattern
\{[String]} escape -- the escape char
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:mod-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:mod-Object_link|trigger=none}{sub-section}{[QBCondition]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:mod-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:mod-Object_sam|trigger=none}{code:language=javascript}
query.resultwhere.add(query.columns.mycol.mod(2companyname.like('X_%', '_'))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=multiplylocate-Object|class=node}{tr:id=name}{td}h6.multiplylocate{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}multiplylocate{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:multiply-Object_des|trigger=button|text=}{sub-section}{sub-section:multiply-Object_des|trigger=none|class=sIndent}Replace with description{sub-section*Parameters*\\{div:class=sIndent}\{[Object]} arg -- string to locate
{div}{td}{tr}{builder-show}{builder-show:permission=edittr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:multiply-Object_snc|trigger=button|text=}{sub-section}{sub-section:multiply-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.locate('sample'))
{code}{div}{td}{tr}{builder-show}{tr:id=prsclass=lastDetailRow}{td}{td}*Parameters*\\{sub-section:multiply-Object_prs|trigger=button|text=}{sub-section}{sub-section:multiply-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- nr to multiply with
{sub-section}{tr}{tbody}{tbody:id=locate-Object_Number}{tr:id=name}{td}h6.locate{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:multiply-Object_ret|trigger=button|text=}{sub-section}{sub-section:multiply-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}locate{span}{span}\(arg, start){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:multiply-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiply-Object_see|trigger=none}{sub-section}\{[Object]} arg -- string to locate
\{[Number]} start -- start pos
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:multiply-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiply-Object_link|trigger=none}{sub-section}{[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:multiply-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiply-Object_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycol.multiply(2locate('sample', 5))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=nulliflt-Object|class=node}{tr:id=name}{td}h6.nulliflt{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunctionQBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}nulliflt{span}{span:id=iets|style=float: left;}\(argvalue){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:nullif-Object_des|trigger=button|text=}{sub-section}{sub-section:nullif-Object_des|trigger=none|class=sIndent}Replace with description{sub-section*Parameters*\\{div:class=sIndent}\{[Object]} value
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncret}{td}*SinceReturns*\\{sub-section:nullif-Object_snc|trigger=button|text=}{sub-section}{sub-section:nullif-Object_snc|trigger=none|div:class=sIndent} Replace with version info{sub-section[QBCondition]{div}{td}{tr}{builder-show}{tr:id=prssam}{td}*ParametersSample*\\{sub-section:nullif-Object_prs|trigger=button|text=}{sub-section}{sub-section:nullif-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- object to compare
{sub-section}{td}{trdiv: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=ret}name}{td}h6.minus{td}*Returns*\\{sub-section:nullif-Object_ret|trigger=button|text=}{sub-section}{sub-section:nullif-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}minus{span}{span}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:nullif-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:nullif-Object_see|trigger=none}{sub-section}\{[Object]} arg -- nr to subtract
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External links*\\{sub-section:nullif-Object_link|trigger=button|text=}{sub-section}Returns*\\{div:class=sIndent}{sub-section:nullif-Object_link|trigger=none}{sub-section}[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:nullif-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:nullif-Object_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycol.nullifminus('none'2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=plusmod-Object|class=node}{tr:id=name}{td}h6.plusmod{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}plusmod{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{tr:id=prs}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:plus-Object_des|trigger=button|text=}{sub-section}{sub-section:plus-Object_des|trigger=none|class=sIndent}Replace with description{sub-section{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- mod arg
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:plus-Object_snc|trigger=button|text=}{sub-section}{sub-section:plus-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.mod(2))
{code}{div}{td}{tr}{builder-show}{tr:id=prsclass=lastDetailRow}{td}{td}*Parameters*\\{sub-section:plus-Object_prs|trigger=button|text=}{sub-section}{sub-section:plus-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- nr to add
{sub-section}{tr}{tbody}{tbody:id=multiply-Object}{tr:id=name}{td}h6.multiply{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:plus-Object_ret|trigger=button|text=}{sub-section}{sub-section:plus-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}multiply{span}{span}\(arg){span}{td}{tr}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:plus-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:plus-Object_see|trigger=none}{sub-section}\{[Object]} arg -- nr to multiply with
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:plus-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:plus-Object_link|trigger=none}{sub-section}[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:plus-Object_sam|trigger=button|text=}{sub-section}:id=sam}{td}*Sample*\\{div:class=sIndent}{sub-section:plus-Object_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycol.plusmultiply(2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=substring-Number|class=nodenullif-Object}{tr:id=name}{td}h6.substringnullif{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}substring{span}{span:id=iets|style=float: left;}\(pos){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:substring-Number_des|trigger=button|text=}{sub-section}{sub-section:substring-Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{span:style=font-weight: bold;}nullif{span}{span}\(arg){span}{td}{tr}{tr:id=sncprs}{td}*SinceParameters*\\{sub-section:substring-Number_snc|trigger=button|text=}{sub-section}{sub-section:substring-Number_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}\{[Object]} arg -- object to compare
{div}{td}{tr}{builder-show}{tr:id=prsret}{td}*ParametersReturns*\\{sub-section:substring-Number_prs|trigger=button|text=}{sub-section}{sub-section:substring-Number_prs|trigger=none|div:class=sIndent}\{[NumberQBFunction]} pos
{sub-section{div}{td}{tr}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:substring-Number_ret|trigger=button|text=}{sub-section}{sub-section:substring-Number_ret|trigger=none|class=sIndent}[QBFunction]{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.nullif('none'))
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-show:permission=edittbody}{tbody:id=plus-Object}{tr:id=name}{td}h6.plus{td}{tr}{tr:id=seesig}{td}*Also see*\\{sub-section:substring-Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Number_see|trigger=none}{sub-section}{div{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}plus{span}{span}\(arg){span}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkprs}{td}*External linksParameters*\\{sub-section:substring-Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Number_link|trigger=none}{sub-section}\{[Object]} arg -- nr to add
{div}{td}{tr}{builder-show}{tr:id=samret}{td}*SampleReturns*\\{sub-section:substring-Number_sam|trigger=button|text=}{sub-section}div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{sub-section:substring-Number_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycol.substringplus(32))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=substring-Number_Number|class=node}{tr:id=name}{td}h6.substring{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}substring{span}{span:id=iets|style=float: left;}\(pos, len){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:substring-Number_Number_des|trigger=button|text=}{sub-section}{sub-section:substring-Number_Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit*Parameters*\\{div:class=sIndent}\{[Number]} pos
{div}{td}{tr}{tr:id=sncret}{td}*SinceReturns*\\{sub-section:substring-Number_Number_snc|trigger=button|text=}{sub-section}{sub-section:substring-Number_Number_snc|trigger=none|div:class=sIndent} Replace with version info{sub-section[QBFunction]{div}{td}{tr}{builder-show}{tr:id=prssam}{td}*ParametersSample*\\{sub-section:substring-Number_Number_prs|trigger=button|text=}{sub-section}{sub-section:substring-Number_Number_prs|trigger=none|class=sIndent}\{[Number]} pos
\{[Number]} len
{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.add(query.columns.mycol.substring(3))
{code}{div}{td}{tr}{tr:id=retclass=lastDetailRow}{td}{td}*Returns*\\{sub-section:substring-Number_Number_ret|trigger=button|text=}{sub-section}{sub-section:{tr}{tbody}{tbody:id=substring-Number_Number_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}}{tr:id=name}{td}h6.substring{td}{tr}{builder-showtr:permission=editid=sig}{td}{trspan:id=see}{td}*Also see*\\{sub-section:substring-Number_Number_see|trigger=button|text=}{sub-section}style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}substring{span}{span}\(pos, len){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}{sub-section:substring-Number_Number_see|trigger=none}{sub-section}\{[Number]} pos
\{[Number]} len
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:substring-Number_Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Number_Number_link|trigger=none}{sub-section}{[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:substring-Number_Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Number_Number_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycol.substring(3, 2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}