Child pages
  • QBFunction

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
{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)
Wiki Markup
Cache
indextrue
refresh100d
showRefreshtrue
iddoc
titleRefresh page
showDatetrue
retryEnable

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy 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 date

servoy 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) expression

propertyservoy sDetail2100%height:30px2Property Detailsabsname

abs

dessIndent
Create abs(column) expression
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRowascname

asc

dessIndent
Create an ascending sort expression
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
avgname

avg

dessIndent
Create an aggregate expression.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
bit_lengthname

bit_length

dessIndent
Create bit_length(column) expression
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
ceilname

ceil

dessIndent
Create ceil(column) expression
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
countname

count

dessIndent
Create an aggregate expression.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
dayname

day

dessIndent
Extract day from date
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
descname

desc

dessIndent
Create an descending sort expression
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
floorname

floor

dessIndent
Create floor(column) expression
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
hourname

hour

dessIndent
Extract hour from date
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
isNullname

isNull

dessIndent
Compare column with null.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
lenname

len

dessIndent
Create length(column) expression
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
lowername

lower

dessIndent
Create lower(column) expression
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
maxname

max

dessIndent
Create an aggregate expression.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
minname

min

dessIndent
Create an aggregate expression.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
minutename

minute

dessIndent
Extract minute from date
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
monthname

month

dessIndent
Extract month from date
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
notname

not

dessIndent
Create a negated condition.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
parentname

parent

dessIndent
Get query builder parent table clause, this may be a query or a join clause.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
rootname

root

dessIndent
Get query builder parent.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
roundname

round

dessIndent
Create round(column) expression
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
secondname

second

dessIndent
Extract second from date
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
sqrtname

sqrt

dessIndent
Create sqrt(column) expression
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
sumname

sum

dessIndent
Create an aggregate expression.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
trimname

trim

dessIndent
Create trim(column) expression
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
uppername

upper

dessIndent
Create upper(column) expression
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
yearname

year

dessIndent
Extract year from date
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow

functionservoy sDetail2100%height:30px2Methods Detailsbetweenname

between(value1, value2)

dessIndent
Compare column to a range of 2 values or other columns.
prs

Parameters

sIndentvalue1 ;value2 ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRowcastname

cast(type)

dessIndent
Create cast(column, type) expression
prs

Parameters

sIndenttypestring type, see QUERY_COLUMN_TYPES
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
concatname

concat(arg)

dessIndent
Concatename with value
prs

Parameters

sIndentargvaleu to concatenate with
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
dividename

divide(arg)

dessIndent
Divide by value
prs

Parameters

sIndentargnr to divide by
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
eqname

eq(value)

dessIndent
Compare column with a value or another column.
{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#like]\(pattern)

Operator: equals
prs

Parameters

sIndentvalue ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
gename

ge(value)

dessIndent
Compare column with a value or another column.
{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#like]\(pattern, escape) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#locate]\(arg) Create locate(arg) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#locate]\(arg, start) Create locate(arg, start) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#lt]\(value) Compare

Operator: greaterThanOrEqual
prs

Parameters

sIndentvalue ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
getFlagsname

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

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
getTypeAsStringname

getTypeAsString()

dessIndent
Column type as a string
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
gtname

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}{tr:id=des}{td}{sub-section:abs_des|trigger=button|text=}{sub-section}{sub-section:abs_des|trigger=none|class=sIndent}Create abs(column) expression{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:asc_des|trigger=button|text=}{sub-section}{sub-section:asc_des|trigger=none|class=sIndent}Create an ascending sort expression{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:avg_des|trigger=button|text=}{sub-section}{sub-section:avg_des|trigger=none|class=sIndent}Create an aggregate expression.{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:bit_length_des|trigger=button|text=}{sub-section}{sub-section:bit_length_des|trigger=none|class=sIndent}Create bit\_length(column) expression{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:ceil_des|trigger=button|text=}{sub-section}{sub-section:ceil_des|trigger=none|class=sIndent}Create ceil(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:ceil_snc|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}{tr:id=des}{td}{sub-section:count_des|trigger=button|text=}{sub-section}{sub-section:count_des|trigger=none|class=sIndent}Create an aggregate expression.{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:day_des|trigger=button|text=}{sub-section}{sub-section:day_des|trigger=none|class=sIndent}Extract day from date{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:day_snc|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}{tr:id=des}{td}{sub-section:desc_des|trigger=button|text=}{sub-section}{sub-section:desc_des|trigger=none|class=sIndent}Create an descending sort expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:desc_snc|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}{tr:id=des}{td}{sub-section:floor_des|trigger=button|text=}{sub-section}{sub-section:floor_des|trigger=none|class=sIndent}Create floor(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:floor_snc|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}{tr:id=des}{td}{sub-section:hour_des|trigger=button|text=}{sub-section}{sub-section:hour_des|trigger=none|class=sIndent}Extract hour from date{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:hour_snc|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}{tr:id=des}{td}{sub-section:isNull_des|trigger=button|text=}{sub-section}{sub-section:isNull_des|trigger=none|class=sIndent}Compare column with null.{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:len_des|trigger=button|text=}{sub-section}{sub-section:len_des|trigger=none|class=sIndent}Create length(column) expression{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:lower_des|trigger=button|text=}{sub-section}{sub-section:lower_des|trigger=none|class=sIndent}Create lower(column) expression{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:max_des|trigger=button|text=}{sub-section}{sub-section:max_des|trigger=none|class=sIndent}Create an aggregate expression.{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:min_des|trigger=button|text=}{sub-section}{sub-section:min_des|trigger=none|class=sIndent}Create an aggregate expression.{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:minute_des|trigger=button|text=}{sub-section}{sub-section:minute_des|trigger=none|class=sIndent}Extract minute from date{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:minute_snc|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}{tr:id=des}{td}{sub-section:month_des|trigger=button|text=}{sub-section}{sub-section:month_des|trigger=none|class=sIndent}Extract month from date{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:month_snc|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}{tr:id=des}{td}{sub-section:not_des|trigger=button|text=}{sub-section}{sub-section:not_des|trigger=none|class=sIndent}Create a negated condition.{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:parent_des|trigger=button|text=}{sub-section}{sub-section:parent_des|trigger=none|class=sIndent}Get query builder parent table clause, this may be a query or a join clause.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:parent_snc|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}{tr:id=des}{td}{sub-section:root_des|trigger=button|text=}{sub-section}{sub-section:root_des|trigger=none|class=sIndent}Get query builder parent.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:root_snc|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}{tr:id=des}{td}{sub-section:round_des|trigger=button|text=}{sub-section}{sub-section:round_des|trigger=none|class=sIndent}Create round(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:round_snc|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}{tr:id=des}{td}{sub-section:second_des|trigger=button|text=}{sub-section}{sub-section:second_des|trigger=none|class=sIndent}Extract second from date{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:second_snc|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}{tr:id=des}{td}{sub-section:sqrt_des|trigger=button|text=}{sub-section}{sub-section:sqrt_des|trigger=none|class=sIndent}Create sqrt(column) expression{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:sum_des|trigger=button|text=}{sub-section}{sub-section:sum_des|trigger=none|class=sIndent}Create an aggregate expression.{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:trim_des|trigger=button|text=}{sub-section}{sub-section:trim_des|trigger=none|class=sIndent}Create trim(column) expression{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:upper_des|trigger=button|text=}{sub-section}{sub-section:upper_des|trigger=none|class=sIndent}Create upper(column) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:upper_snc|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}{tr:id=des}{td}{sub-section:year_des|trigger=button|text=}{sub-section}{sub-section:year_des|trigger=none|class=sIndent}Extract year from date{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:year_snc|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}{tr:id=des}{td}{sub-section:between_des|trigger=button|text=}{sub-section}{sub-section:between_des|trigger=none|class=sIndent}Compare column to a range of 2 values or other columns.{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:cast_des|trigger=button|text=}{sub-section}{sub-section:cast_des|trigger=none|class=sIndent}Create cast(column, type) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:cast_snc|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}{tr:id=des}{td}{sub-section:concat_des|trigger=button|text=}{sub-section}{sub-section:concat_des|trigger=none|class=sIndent}Concatename with value{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:divide_des|trigger=button|text=}{sub-section}{sub-section:divide_des|trigger=none|class=sIndent}Divide by value{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:divide_snc|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}{tr:id=des}{td}{sub-section:eq_des|trigger=button|text=}{sub-section}{sub-section:eq_des|trigger=none|class=sIndent}Compare column with a value or another column. Operator: equals{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:ge_des|trigger=button|text=}{sub-section}{sub-section:ge_des|trigger=none|class=sIndent}Compare column with a value or another column. Operator: greaterThanOrEqual{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:ge_snc|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}{tr:id=des}{td}{sub-section:gt_des|trigger=button|text=}{sub-section}{sub-section:gt_des|trigger=none|class=sIndent}Compare column with a value or another column. Operator: greaterThan{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:gt_snc|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}{tr:id=des}{td}{sub-section:isin-QBPart_des|trigger=button|text=}{sub-section}{sub-section:isin-QBPart_des|trigger=none|class=sIndent}Compare column with subquery result.{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:isin-ObjectArray_des|trigger=button|text=}{sub-section}{sub-section:isin-ObjectArray_des|trigger=none|class=sIndent}Compare column with values.{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:le_des|trigger=button|text=}{sub-section}{sub-section:le_des|trigger=none|class=sIndent}Compare column with a value or another column. Operator: lessThanOrEqual{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:le_snc|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}{tr:id=des}{td}{sub-section:like-String_des|trigger=button|text=}{sub-section}{sub-section:like-String_des|trigger=none|class=sIndent}Compare column with a value or another column. Operator: like{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:like-String_snc|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}{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}Compare column with a value or another column. Operator: like, with escape character{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:like-String_String_snc|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}{tr:id=des}{td}{sub-section:locate-Object_des|trigger=button|text=}{sub-section}{sub-section:locate-Object_des|trigger=none|class=sIndent}Create locate(arg) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:locate-Object_snc|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}{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}Create locate(arg, start) expression{sub-section}{td}{tr}{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}{tr:id=des}{td}{sub-section:lt_des|trigger=button|text=}{sub-section}{sub-section:lt_des|trigger=none|class=sIndent}Compare column with a value or another column. Operator: lessThan{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:lt_snc|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}{tr:id=des}{td}{sub-section:minus_des|trigger=button|text=}{sub-section}{sub-section:minus_des|trigger=none|class=sIndent}Subtract value{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:minus_snc|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}{tr:id=des}{td}{sub-section:mod_des|trigger=button|text=}{sub-section}{sub-section:mod_des|trigger=none|class=sIndent}Create mod(arg) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:mod_snc|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}{tr:id=des}{td}{sub-section:multiply_des|trigger=button|text=}{sub-section}{sub-section:multiply_des|trigger=none|class=sIndent}Multiply with value{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:multiply_snc|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}{tr:id=des}{td}{sub-section:nullif_des|trigger=button|text=}{sub-section}{sub-section:nullif_des|trigger=none|class=sIndent}Create nullif(arg) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:nullif_snc|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}{tr:id=des}{td}{sub-section:plus_des|trigger=button|text=}{sub-section}{sub-section:plus_des|trigger=none|class=sIndent}Add up value{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:plus_snc|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}{tr:id=des}{td}{sub-section:substring-Number_des|trigger=button|text=}{sub-section}{sub-section:substring-Number_des|trigger=none|class=sIndent}Create substring(pos) expression{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:substring-Number_snc|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}{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}Create substring(pos, len) expression{sub-section}{td}{tr}{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}

Operator: greaterThan
prs

Parameters

sIndentvalue ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
isinname

isin(query)

dessIndent
Compare column with subquery result.
prs

Parameters

sIndentquerysubquery
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
isinname

isin(values)

dessIndent
Compare column with values.
prs

Parameters

sIndentvaluesarray of values
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
isinname

isin(customQuery, args)

dessIndent
Compare column with custom query result.
prs

Parameters

sIndentcustomQuerycustom queryargsquery arguments
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
lename

le(value)

dessIndent
Compare column with a value or another column.
Operator: lessThanOrEqual
prs

Parameters

sIndentvalue ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
likename

like(pattern)

dessIndent
Compare column with a value or another column.
Operator: like
prs

Parameters

sIndentpatternthe string value of the pattern
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
likename

like(pattern, escape)

dessIndent
Compare column with a value or another column.
Operator: like, with escape character
prs

Parameters

sIndentpatternthe string value of the patternescapethe escape char
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
locatename

locate(arg)

dessIndent
Create locate(arg) expression
prs

Parameters

sIndentargstring to locate
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
locatename

locate(arg, start)

dessIndent
Create locate(arg, start) expression
prs

Parameters

sIndentargstring to locatestartstart pos
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
ltname

lt(value)

dessIndent
Compare column with a value or another column.
Operator: lessThan
prs

Parameters

sIndentvalue ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
minusname

minus(arg)

dessIndent
Subtract value
prs

Parameters

sIndentargnr to subtract
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
modname

mod(arg)

dessIndent
Create mod(arg) expression
prs

Parameters

sIndentargmod arg
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
multiplyname

multiply(arg)

dessIndent
Multiply with value
prs

Parameters

sIndentargnr to multiply with
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
nullifname

nullif(arg)

dessIndent
Create nullif(arg) expression
prs

Parameters

sIndentargobject to compare
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
plusname

plus(arg)

dessIndent
Add up value
prs

Parameters

sIndentargnr to add
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
substringname

substring(pos)

dessIndent
Create substring(pos) expression
prs

Parameters

sIndentpos ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
substringname

substring(pos, len)

dessIndent
Create substring(pos, len) expression
prs

Parameters

sIndentpos ;len ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow