{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:padding=0px|width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Property Summary{th}{tr}{tbody}{tr}{td}[QBFunction]{td}{td}[#abs]
Create upper(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBSort]{td}{td}[#asc]
Create an ascending sort expression
<pre>
query.{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 upper(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 a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#len]
Create upper(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#lower]
Create upper(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 upper(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 upper(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:padding=0px|width=80px}{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 with a value or another column.{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}[#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:padding=0px|width=100%}{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}{tr:id=des}{td}{sub-section:abs_des|text=|trigger=button}{sub-section}{sub-section:abs_des|trigger=none|class=sIndent}Create upper(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:abs_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:asc_des|text=|trigger=button}{sub-section}{sub-section:asc_des|trigger=none|class=sIndent}Create an ascending sort expression
<pre>
query.sort().add(query.getColumn("value").asc());
</pre>{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:asc_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:avg_des|text=|trigger=button}{sub-section}{sub-section:avg_des|trigger=none|class=sIndent}Create an aggregate expression.
Aggregate: avg{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:avg_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:bit_length_des|text=|trigger=button}{sub-section}{sub-section:bit_length_des|trigger=none|class=sIndent}Create upper(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:bit_length_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:ceil_des|text=|trigger=button}{sub-section}{sub-section:ceil_des|trigger=none|class=sIndent}Create ceil(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:ceil_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:count_des|text=|trigger=button}{sub-section}{sub-section:count_des|trigger=none|class=sIndent}Create an aggregate expression.
Aggregate: count
<pre>
// select value, count(value) from tab group by value order by count(value) desc 
query.result().add(query.getColumn("value")).add(query.getColumn("value").count())
    .getParent().groupBy().add("value")
    .getParent().sort().add(query.getColumn("value").count().desc());
</pre>{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:count_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:day_des|text=|trigger=button}{sub-section}{sub-section:day_des|trigger=none|class=sIndent}Extract day from date{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:day_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:desc_des|text=|trigger=button}{sub-section}{sub-section:desc_des|trigger=none|class=sIndent}Create an descending sort expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:desc_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:floor_des|text=|trigger=button}{sub-section}{sub-section:floor_des|trigger=none|class=sIndent}Create floor(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:floor_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:hour_des|text=|trigger=button}{sub-section}{sub-section:hour_des|trigger=none|class=sIndent}Extract hour from date{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:hour_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:isNull_des|text=|trigger=button}{sub-section}{sub-section:isNull_des|trigger=none|class=sIndent}Compare column with a value or another column.
Operator: isNull{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:isNull_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:len_des|text=|trigger=button}{sub-section}{sub-section:len_des|trigger=none|class=sIndent}Create upper(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:len_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:lower_des|text=|trigger=button}{sub-section}{sub-section:lower_des|trigger=none|class=sIndent}Create upper(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:lower_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:max_des|text=|trigger=button}{sub-section}{sub-section:max_des|trigger=none|class=sIndent}Create an aggregate expression.
Aggregate: max{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:max_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:min_des|text=|trigger=button}{sub-section}{sub-section:min_des|trigger=none|class=sIndent}Create an aggregate expression.
Aggregate: min{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:min_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:minute_des|text=|trigger=button}{sub-section}{sub-section:minute_des|trigger=none|class=sIndent}Extract minute from date{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:minute_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:month_des|text=|trigger=button}{sub-section}{sub-section:month_des|trigger=none|class=sIndent}Extract month from date{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:month_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:not_des|text=|trigger=button}{sub-section}{sub-section:not_des|trigger=none|class=sIndent}Create a negated condition.
<pre>
query.where().add(query.getColumn("value").not().eq(new Integer(100));
</pre>{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:not_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:parent_des|text=|trigger=button}{sub-section}{sub-section:parent_des|trigger=none|class=sIndent}Get query builder parent table clause, this may be a query or a join clause.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:parent_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:root_des|text=|trigger=button}{sub-section}{sub-section:root_des|trigger=none|class=sIndent}Get query builder parent.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:root_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:round_des|text=|trigger=button}{sub-section}{sub-section:round_des|trigger=none|class=sIndent}Create round(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:round_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:second_des|text=|trigger=button}{sub-section}{sub-section:second_des|trigger=none|class=sIndent}Extract second from date{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:second_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:sqrt_des|text=|trigger=button}{sub-section}{sub-section:sqrt_des|trigger=none|class=sIndent}Create upper(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:sqrt_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:sum_des|text=|trigger=button}{sub-section}{sub-section:sum_des|trigger=none|class=sIndent}Create an aggregate expression.
Aggregate: sum{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:sum_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:trim_des|text=|trigger=button}{sub-section}{sub-section:trim_des|trigger=none|class=sIndent}Create upper(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:trim_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:upper_des|text=|trigger=button}{sub-section}{sub-section:upper_des|trigger=none|class=sIndent}Create upper(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:upper_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:year_des|text=|trigger=button}{sub-section}{sub-section:year_des|trigger=none|class=sIndent}Extract year from date{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:year_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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:padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=between|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}{tr:id=des}{td}{sub-section:between_des|text=|trigger=button}{sub-section}{sub-section:between_des|trigger=none|class=sIndent}Compare column with a value or another column.
Compare column to between 2 values or other columns.
<pre>
query.where().add(query.getColumn("value").between(new Integer(1), new Integer(99));
</pre>{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:between_snc|text=|trigger=button}{sub-section}{sub-section:between_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:between_prs|text=|trigger=button}{sub-section}{sub-section:between_prs|trigger=none|class=sIndent}\{[Object]} value1
\{[Object]} value2
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:between_ret|text=|trigger=button}{sub-section}{sub-section:between_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:between_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:between_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:between_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:between_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:between_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:between_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|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}{tr:id=des}{td}{sub-section:cast_des|text=|trigger=button}{sub-section}{sub-section:cast_des|trigger=none|class=sIndent}Create cast(column, type) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:cast_snc|text=|trigger=button}{sub-section}{sub-section:cast_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:cast_prs|text=|trigger=button}{sub-section}{sub-section:cast_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_ret|text=|trigger=button}{sub-section}{sub-section:cast_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:cast_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:cast_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:cast_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:cast_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:cast_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:cast_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=divide|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}{tr:id=des}{td}{sub-section:divide_des|text=|trigger=button}{sub-section}{sub-section:divide_des|trigger=none|class=sIndent}Divide by value{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:divide_snc|text=|trigger=button}{sub-section}{sub-section:divide_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:divide_prs|text=|trigger=button}{sub-section}{sub-section:divide_prs|trigger=none|class=sIndent}\{[Object]} arg -- nr to divide by
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:divide_ret|text=|trigger=button}{sub-section}{sub-section:divide_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:divide_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:divide_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:divide_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:divide_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:divide_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:divide_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|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}{tr:id=des}{td}{sub-section:eq_des|text=|trigger=button}{sub-section}{sub-section:eq_des|trigger=none|class=sIndent}Compare column with a value or another column.
Operator: equals
<pre>
query.where().add(query.getColumn("value").eq(new Integer(100));
</pre>{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:eq_snc|text=|trigger=button}{sub-section}{sub-section:eq_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:eq_prs|text=|trigger=button}{sub-section}{sub-section:eq_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:eq_ret|text=|trigger=button}{sub-section}{sub-section:eq_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:eq_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:eq_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:eq_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:eq_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:eq_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:eq_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|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}{tr:id=des}{td}{sub-section:ge_des|text=|trigger=button}{sub-section}{sub-section:ge_des|trigger=none|class=sIndent}Compare column with a value or another column.
Operator: greaterThanOrEqual{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:ge_snc|text=|trigger=button}{sub-section}{sub-section:ge_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:ge_prs|text=|trigger=button}{sub-section}{sub-section:ge_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:ge_ret|text=|trigger=button}{sub-section}{sub-section:ge_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:ge_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:ge_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:ge_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:ge_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:ge_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:ge_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|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}{tr:id=des}{td}{sub-section:gt_des|text=|trigger=button}{sub-section}{sub-section:gt_des|trigger=none|class=sIndent}Compare column with a value or another column.
Operator: greaterThan{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:gt_snc|text=|trigger=button}{sub-section}{sub-section:gt_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:gt_prs|text=|trigger=button}{sub-section}{sub-section:gt_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:gt_ret|text=|trigger=button}{sub-section}{sub-section:gt_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:gt_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:gt_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:gt_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:gt_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:gt_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:gt_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}{tr:id=des}{td}{sub-section:isin-QBPart_des|text=|trigger=button}{sub-section}{sub-section:isin-QBPart_des|trigger=none|class=sIndent}Compare column with subquery result.
<pre>
query.where().add(query.getColumn("value").in(subQuery.result().add(query.getColumn("code")).getParent().where().add(subQuery.getColumn("flag").eq("T"))));
</pre>{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:isin-QBPart_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isin-QBPart_sam|trigger=none}{code:language=javascript}
query.where.add(query.columns.flag.in(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}{tr:id=des}{td}{sub-section:isin-ObjectArray_des|text=|trigger=button}{sub-section}{sub-section:isin-ObjectArray_des|trigger=none|class=sIndent}Compare column with values.
<pre>
query.where().add(query.getColumn("value").in(subQuery.result().add(new Object\[\]\{Integer.valueOf(1), Integer.valueof(100)});
</pre>{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:isin-ObjectArray_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isin-ObjectArray_sam|trigger=none}{code:language=javascript}
query.where.add(query.columns.flag.in([1, 5, 99]))
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=le|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}{tr:id=des}{td}{sub-section:le_des|text=|trigger=button}{sub-section}{sub-section:le_des|trigger=none|class=sIndent}Compare column with a value or another column.
Operator: lessThanOrEqual{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:le_snc|text=|trigger=button}{sub-section}{sub-section:le_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:le_prs|text=|trigger=button}{sub-section}{sub-section:le_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:le_ret|text=|trigger=button}{sub-section}{sub-section:le_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:le_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:le_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:le_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:le_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:le_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:le_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}{tr:id=des}{td}{sub-section:like-String_des|text=|trigger=button}{sub-section}{sub-section:like-String_des|trigger=none|class=sIndent}Compare column with a value or another column.
Operator: like{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:like-String_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:like-String_String_des|text=|trigger=button}{sub-section}{sub-section:like-String_String_des|trigger=none|class=sIndent}Compare column with a value or another column.
Operator: like, with escape character{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:like-String_String_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:locate-Object_des|text=|trigger=button}{sub-section}{sub-section:locate-Object_des|trigger=none|class=sIndent}Create locate(arg) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:locate-Object_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:locate-Object_Number_des|text=|trigger=button}{sub-section}{sub-section:locate-Object_Number_des|trigger=none|class=sIndent}Create locate(arg, start) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:locate-Object_Number_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|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}{tr:id=des}{td}{sub-section:lt_des|text=|trigger=button}{sub-section}{sub-section:lt_des|trigger=none|class=sIndent}Compare column with a value or another column.
Operator: lessThan{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:lt_snc|text=|trigger=button}{sub-section}{sub-section:lt_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:lt_prs|text=|trigger=button}{sub-section}{sub-section:lt_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:lt_ret|text=|trigger=button}{sub-section}{sub-section:lt_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:lt_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:lt_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:lt_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:lt_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:lt_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:lt_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|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}{tr:id=des}{td}{sub-section:minus_des|text=|trigger=button}{sub-section}{sub-section:minus_des|trigger=none|class=sIndent}Subtract value{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:minus_snc|text=|trigger=button}{sub-section}{sub-section:minus_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:minus_prs|text=|trigger=button}{sub-section}{sub-section:minus_prs|trigger=none|class=sIndent}\{[Object]} arg -- nr to subtract
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:minus_ret|text=|trigger=button}{sub-section}{sub-section:minus_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:minus_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:minus_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:minus_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:minus_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:minus_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:minus_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|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}{tr:id=des}{td}{sub-section:mod_des|text=|trigger=button}{sub-section}{sub-section:mod_des|trigger=none|class=sIndent}Create mod(arg) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:mod_snc|text=|trigger=button}{sub-section}{sub-section:mod_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:mod_prs|text=|trigger=button}{sub-section}{sub-section:mod_prs|trigger=none|class=sIndent}\{[Object]} arg -- mod arg
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:mod_ret|text=|trigger=button}{sub-section}{sub-section:mod_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:mod_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:mod_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:mod_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:mod_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:mod_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:mod_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|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}{tr:id=des}{td}{sub-section:multiply_des|text=|trigger=button}{sub-section}{sub-section:multiply_des|trigger=none|class=sIndent}Multiply with value{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:multiply_snc|text=|trigger=button}{sub-section}{sub-section:multiply_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:multiply_prs|text=|trigger=button}{sub-section}{sub-section:multiply_prs|trigger=none|class=sIndent}\{[Object]} arg -- nr to multiply with
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:multiply_ret|text=|trigger=button}{sub-section}{sub-section:multiply_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:multiply_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:multiply_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:multiply_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:multiply_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:multiply_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:multiply_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|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}{tr:id=des}{td}{sub-section:nullif_des|text=|trigger=button}{sub-section}{sub-section:nullif_des|trigger=none|class=sIndent}Create nullif(arg) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:nullif_snc|text=|trigger=button}{sub-section}{sub-section:nullif_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:nullif_prs|text=|trigger=button}{sub-section}{sub-section:nullif_prs|trigger=none|class=sIndent}\{[Object]} arg -- object to compare
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:nullif_ret|text=|trigger=button}{sub-section}{sub-section:nullif_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:nullif_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:nullif_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:nullif_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:nullif_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:nullif_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:nullif_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|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}{tr:id=des}{td}{sub-section:plus_des|text=|trigger=button}{sub-section}{sub-section:plus_des|trigger=none|class=sIndent}Add up value{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:plus_snc|text=|trigger=button}{sub-section}{sub-section:plus_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:plus_prs|text=|trigger=button}{sub-section}{sub-section:plus_prs|trigger=none|class=sIndent}\{[Object]} arg -- nr to add
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:plus_ret|text=|trigger=button}{sub-section}{sub-section:plus_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:plus_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:plus_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:plus_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:plus_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:plus_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:plus_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}{tr:id=des}{td}{sub-section:substring-Number_des|text=|trigger=button}{sub-section}{sub-section:substring-Number_des|trigger=none|class=sIndent}Create substring(pos) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:substring-Number_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:substring-Number_Number_des|text=|trigger=button}{sub-section}{sub-section:substring-Number_Number_des|trigger=none|class=sIndent}Create substring(pos, len) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:substring-Number_Number_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}