{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)
Cache
index
true
refresh
100d
showRefresh
true
id
doc
title
Refresh page
showDate
true
retry
Enable
servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientservoy sSummary12%30%58%height: 30px;3Property SummaryCreate abs(column) expressionCreate an ascending sort expressionCreate an aggregate expression.Create bit_length(column) expressionCreate ceil(column) expressionCreate an aggregate expression.Extract day from dateCreate an descending sort expressionCreate floor(column) expressionExtract hour from dateCompare column with null.Create length(column) expressionCreate lower(column) expressionCreate an aggregate expression.Create an aggregate expression.Extract minute from dateExtract month from dateCreate a negated condition.Get query builder parent table clause, this may be a query or a join clause.Get query builder parent.Create round(column) expressionExtract second from dateCreate sqrt(column) expressionCreate an aggregate expression.Create trim(column) expressionCreate upper(column) expressionExtract year from dateservoy sSummary12%30%58%height: 30px;3Methods SummaryCompare column to a range of 2 values or other columns.Create cast(column, type) expressionConcatename with valueDivide by valueCompare column with a value or another column.Compare column with a value or another column.The flags are a bit pattern consisting of 1 or more of the following bits: - JSColumn.Column type as a stringCompare column with a value or another column.Compare column with subquery result.Compare column with values.Compare column with custom query result.Compare column with a value or another column.Compare column with a value or another column.Compare column with a value or another column.Create locate(arg) expressionCreate locate(arg, start) expressionCompare column with a value or another column.Subtract valueCreate mod(arg) expressionMultiply with valueCreate nullif(arg) expressionAdd up valueCreate substring(pos) expressionCreate substring(pos, len) expressionpropertyservoy sDetail2100%height:30px2Property Detailsabsname
abs
dessIndent
Create abs(column) expression
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowascname
asc
dessIndent
Create an ascending sort expression
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowavgname
avg
dessIndent
Create an aggregate expression.
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowbit_lengthname
bit_length
dessIndent
Create bit_length(column) expression
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowceilname
ceil
dessIndent
Create ceil(column) expression
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowcountname
count
dessIndent
Create an aggregate expression.
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowdayname
day
dessIndent
Extract day from date
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowdescname
desc
dessIndent
Create an descending sort expression
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowfloorname
floor
dessIndent
Create floor(column) expression
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowhourname
hour
dessIndent
Extract hour from date
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowisNullname
isNull
dessIndent
Compare column with null.
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowlenname
len
dessIndent
Create length(column) expression
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowlowername
lower
dessIndent
Create lower(column) expression
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowmaxname
max
dessIndent
Create an aggregate expression.
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowminname
min
dessIndent
Create an aggregate expression.
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowminutename
minute
dessIndent
Extract minute from date
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowmonthname
month
dessIndent
Extract month from date
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRownotname
not
dessIndent
Create a negated condition.
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowparentname
parent
dessIndent
Get query builder parent table clause, this may be a query or a join clause.
{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
Operator: greaterThanOrEqual
prs
Parameters
sIndentvalue ;ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetFlagsname
getFlags()
dessIndent
The flags are a bit pattern consisting of 1 or more of the following bits:
- JSColumn.UUID_COLUMN
- JSColumn.EXCLUDED_COLUMN
- JSColumn.TENANT_COLUMN
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetTypeAsStringname
getTypeAsString()
dessIndent
Column type as a string
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgtname
gt(value)
dessIndent
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|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_des|trigger=button|text=}{sub-section}{sub-section:between_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:cast_des|trigger=button|text=}{sub-section}{sub-section:cast_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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=concat|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_des|trigger=button|text=}{sub-section}{sub-section:concat_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_snc|trigger=button|text=}{sub-section}{sub-section:concat_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:concat_prs|trigger=button|text=}{sub-section}{sub-section:concat_prs|trigger=none|class=sIndent}\{[Object]} arg -- valeu to concatenate with
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:concat_ret|trigger=button|text=}{sub-section}{sub-section:concat_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:concat_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:concat_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:concat_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:concat_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:concat_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:concat_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|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_des|trigger=button|text=}{sub-section}{sub-section:divide_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:eq_des|trigger=button|text=}{sub-section}{sub-section:eq_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:ge_des|trigger=button|text=}{sub-section}{sub-section:ge_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:gt_des|trigger=button|text=}{sub-section}{sub-section:gt_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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}{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|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_des|trigger=button|text=}{sub-section}{sub-section:le_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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}{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|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_des|trigger=button|text=}{sub-section}{sub-section:lt_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:minus_des|trigger=button|text=}{sub-section}{sub-section:minus_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:mod_des|trigger=button|text=}{sub-section}{sub-section:mod_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:multiply_des|trigger=button|text=}{sub-section}{sub-section:multiply_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:nullif_des|trigger=button|text=}{sub-section}{sub-section:nullif_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:plus_des|trigger=button|text=}{sub-section}{sub-section:plus_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_snc|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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|trigger=button|text=}{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}{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}