Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
{hidden}
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE{hidden}
{sub-section:description|text=}{sub-section}\\ 

{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=des}{td}{sub-section:abs_des|trigger=button|text=}{sub-section}{sub-section:abs_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:abs_snc|trigger=button|text=}{sub-section}{sub-section:abs_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:abs_prs|trigger=button|text=}{sub-section}{sub-section:abs_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:abs_ret|trigger=button|text=}{sub-section}{sub-section:abs_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{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}{td}*External links*\\{sub-section:abs_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:abs_link|trigger=none}{sub-section}{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}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=asc|class=node}{tr:id=name}{td}h6.asc{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:asc_des|trigger=button|text=}{sub-section}{sub-section:asc_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:asc_snc|trigger=button|text=}{sub-section}{sub-section:asc_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:asc_prs|trigger=button|text=}{sub-section}{sub-section:asc_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:asc_ret|trigger=button|text=}{sub-section}{sub-section:asc_ret|trigger=none|class=sIndent}[QBSort]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:asc_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:asc_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:asc_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:asc_link|trigger=none}{sub-section}{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
.add(query.joins.orders_to_order_details.columns.quantity.asc)
.add(query.columns.companyid)
foundset.loadRecords(query)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=avg|class=node}{tr:id=name}{td}h6.avg{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:avg_des|trigger=button|text=}{sub-section}{sub-section:avg_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:avg_snc|trigger=button|text=}{sub-section}{sub-section:avg_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:avg_prs|trigger=button|text=}{sub-section}{sub-section:avg_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:avg_ret|trigger=button|text=}{sub-section}{sub-section:avg_ret|trigger=none|class=sIndent}[QBAggregate]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:avg_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:avg_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:avg_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:avg_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:avg_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:avg_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.avg.eq(1))
	foundset.loadRecords(query)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=bit_length|class=node}{tr:id=name}{td}h6.bit_length{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:bit_length_des|trigger=button|text=}{sub-section}{sub-section:bit_length_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:bit_length_snc|trigger=button|text=}{sub-section}{sub-section:bit_length_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:bit_length_prs|trigger=button|text=}{sub-section}{sub-section:bit_length_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:bit_length_ret|trigger=button|text=}{sub-section}{sub-section:bit_length_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:bit_length_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:bit_length_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{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:id=sam}{td}*Sample*\\{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}{td}{tr}{tr:class=lastDetailRow}{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}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{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}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:ceil_prs|trigger=button|text=}{sub-section}{sub-section:ceil_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:ceil_ret|trigger=button|text=}{sub-section}{sub-section:ceil_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:ceil_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ceil_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:ceil_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ceil_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:ceil_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ceil_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycol.ceil)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=count|class=node}{tr:id=name}{td}h6.count{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:count_des|trigger=button|text=}{sub-section}{sub-section:count_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:count_snc|trigger=button|text=}{sub-section}{sub-section:count_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:count_prs|trigger=button|text=}{sub-section}{sub-section:count_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:count_ret|trigger=button|text=}{sub-section}{sub-section:count_ret|trigger=none|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}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:count_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:count_link|trigger=none}{sub-section}{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>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.eq(0))
	foundset.loadRecords(query)
{code}{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}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:le-Object_ret|trigger=button|text=}{sub-section}{sub-section:le-Object_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:le-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:le-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:le-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:le-Object_link|trigger=none}{sub-section}{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.where.add(query.columns.flag.le(2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=like-String|class=node}{tr:id=name}{td}h6.like{td}{tr}{tr:id=sig}{td}{span: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=edit}{tr:id=des}{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}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{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}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:like-String_prs|trigger=button|text=}{sub-section}{sub-section:like-String_prs|trigger=none|class=sIndent}\{[String]} pattern -- the string value of the pattern
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:like-String_ret|trigger=button|text=}{sub-section}{sub-section:like-String_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{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-show}{builder-show:permission=edit}{tr:id=link}{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}{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.where.add(query.columns.companyname.like('Serv%'))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=like-String_String|class=node}{tr:id=name}{td}h6.like{td}{tr}{tr:id=sig}{td}{span: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){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{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=edit}{tr:id=snc}{td}*Since*\\{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-section}{td}{tr}{builder-show}{tr:id=prs}{td}*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}{td}{tr}{tr:id=ret}{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}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:like-String_String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:like-String_String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:like-String_String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:like-String_String_link|trigger=none}{sub-section}{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.companyname.like('X_%', '_'))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locate-Object|class=node}{tr:id=name}{td}h6.locate{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}locate{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:locate-Object_des|trigger=button|text=}{sub-section}{sub-section:locate-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:locate-Object_snc|trigger=button|text=}{sub-section}{sub-section:locate-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{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}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:locate-Object_ret|trigger=button|text=}{sub-section}{sub-section:locate-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:locate-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:locate-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_link|trigger=none}{sub-section}{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.mycol.locate('sample'))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locate-Object_Number|class=node}{tr:id=name}{td}h6.locate{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}locate{span}{span:id=iets|style=float: left;}\(arg, start){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{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}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{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}{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-section}{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=edit}{tr:id=see}{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}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:locate-Object_Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Number_link|trigger=none}{sub-section}{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.result.add(query.columns.mycol.locate('sample', 5))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=lt-Object|class=node}{tr:id=name}{td}h6.lt{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}lt{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:lt-Object_des|trigger=button|text=}{sub-section}{sub-section:lt-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:lt-Object_snc|trigger=button|text=}{sub-section}{sub-section:lt-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{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}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:lt-Object_ret|trigger=button|text=}{sub-section}{sub-section:lt-Object_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:lt-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lt-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:lt-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lt-Object_link|trigger=none}{sub-section}{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.lt(99))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minus-Object|class=node}{tr:id=name}{td}h6.minus{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}minus{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{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}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:minus-Object_snc|trigger=button|text=}{sub-section}{sub-section:minus-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{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-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:minus-Object_ret|trigger=button|text=}{sub-section}{sub-section:minus-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:minus-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minus-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:minus-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minus-Object_link|trigger=none}{sub-section}{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.result.add(query.columns.mycol.minus(2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=mod-Object|class=node}{tr:id=name}{td}h6.mod{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}mod{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{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}{tr:id=snc}{td}*Since*\\{sub-section:mod-Object_snc|trigger=button|text=}{sub-section}{sub-section:mod-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{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}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:mod-Object_ret|trigger=button|text=}{sub-section}{sub-section:mod-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:mod-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:mod-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:mod-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:mod-Object_link|trigger=none}{sub-section}{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.result.add(query.columns.mycol.mod(2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=multiply-Object|class=node}{tr:id=name}{td}h6.multiply{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}multiply{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{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}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:multiply-Object_snc|trigger=button|text=}{sub-section}{sub-section:multiply-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{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}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:multiply-Object_ret|trigger=button|text=}{sub-section}{sub-section:multiply-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:multiply-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiply-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:multiply-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiply-Object_link|trigger=none}{sub-section}{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(2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=nullif-Object|class=node}{tr:id=name}{td}h6.nullif{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}nullif{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{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}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:nullif-Object_snc|trigger=button|text=}{sub-section}{sub-section:nullif-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{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}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:nullif-Object_ret|trigger=button|text=}{sub-section}{sub-section:nullif-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:nullif-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:nullif-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:nullif-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:nullif-Object_link|trigger=none}{sub-section}{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.nullif('none'))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=plus-Object|class=node}{tr:id=name}{td}h6.plus{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}plus{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{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}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:plus-Object_snc|trigger=button|text=}{sub-section}{sub-section:plus-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{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}{td}{tr}{tr:id=ret}{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}{tr:id=see}{td}*Also see*\\{sub-section:plus-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:plus-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:plus-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:plus-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:plus-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:plus-Object_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycol.plus(2))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=substring-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){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}{tr:id=snc}{td}*Since*\\{sub-section:substring-Number_snc|trigger=button|text=}{sub-section}{sub-section:substring-Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:substring-Number_prs|trigger=button|text=}{sub-section}{sub-section:substring-Number_prs|trigger=none|class=sIndent}\{[Number]} pos
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:substring-Number_ret|trigger=button|text=}{sub-section}{sub-section:substring-Number_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{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}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:substring-Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:substring-Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Number_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.mycol.substring(3))
{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=des}{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}{tr:id=snc}{td}*Since*\\{sub-section:substring-Number_Number_snc|trigger=button|text=}{sub-section}{sub-section:substring-Number_Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{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-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:substring-Number_Number_ret|trigger=button|text=}{sub-section}{sub-section:substring-Number_Number_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:substring-Number_Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Number_Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:substring-Number_Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Number_Number_link|trigger=none}{sub-section}{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}