Child pages
  • QBFunction

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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.Compare 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

dessIndentCreate abs(column) expressionret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow ascname

asc

dessIndentCreate an ascending sort expressionret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
avgname

avg

dessIndentCreate an aggregate expression.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
bit_lengthname

bit_length

dessIndentCreate bit_length(column) expressionret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
ceilname

ceil

dessIndentCreate ceil(column) expressionret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
countname

count

dessIndentCreate an aggregate expression.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
dayname

day

dessIndentExtract day from dateret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
descname

desc

dessIndentCreate an descending sort expressionret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
floorname

floor

dessIndentCreate floor(column) expressionret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
hourname

hour

dessIndentExtract hour from dateret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
isNullname

isNull

dessIndentCompare column with null.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
lenname

len

dessIndentCreate length(column) expressionret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
lowername

lower

dessIndentCreate lower(column) expressionret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
maxname

max

dessIndentCreate an aggregate expression.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
minname

min

dessIndentCreate an aggregate expression.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
minutename

minute

dessIndentExtract minute from dateret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
monthname

month

dessIndentExtract month from dateret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
notname

not

dessIndentCreate a negated condition.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
parentname

parent

dessIndentGet 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

dessIndentGet query builder parent.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
roundname

round

dessIndentCreate round(column) expressionret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
secondname

second

dessIndentExtract second from dateret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
sqrtname

sqrt

dessIndentCreate sqrt(column) expressionret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
sumname

sum

dessIndentCreate an aggregate expression.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
trimname

trim

dessIndentCreate trim(column) expressionret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
uppername

upper

dessIndentCreate upper(column) expressionret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
yearname

year

dessIndentExtract year from dateret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 

functionservoy sDetail2100%height:30px2Methods Detailsbetweenname

between(value1, value2)

dessIndentCompare 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
lastDetailRow castname

cast(type)

dessIndentCreate cast(column, type) expressionprs

Parameters

sIndenttypestring type, see QUERY_COLUMN_TYPES
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
concatname

concat(arg)

dessIndentConcatename with valueprs

Parameters

sIndentargvaleu to concatenate with
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
dividename

divide(arg)

dessIndentDivide by valueprs

Parameters

sIndentargnr to divide by
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
eqname

eq(value)

dessIndentCompare column with a value or another column. Operator: equalsprs

Parameters

sIndentvalue 
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
gename

ge(value)

dessIndentCompare column with a value or another column. Operator: greaterThanOrEqualprs

Parameters

sIndentvalue 
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
gtname

gt(value)

dessIndentCompare column with a value or another column. Operator: greaterThanprs

Parameters

sIndentvalue 
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
isinname

isin(query)

dessIndentCompare column with subquery result.prs

Parameters

sIndentquerysubquery
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
isinname

isin(values)

dessIndentCompare 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)

dessIndentCompare 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)

dessIndentCompare column with a value or another column. Operator: lessThanOrEqualprs

Parameters

sIndentvalue 
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
likename

like(pattern)

dessIndentCompare column with a value or another column. Operator: likeprs

Parameters

sIndentpatternthe string value of the pattern
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
likename

like(pattern, escape)

dessIndentCompare column with a value or another column. Operator: like, with escape characterprs

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)

dessIndentCreate locate(arg) expressionprs

Parameters

sIndentargstring to locate
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
locatename

locate(arg, start)

dessIndentCreate locate(arg, start) expressionprs

Parameters

sIndentargstring to locatestartstart pos
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
ltname

lt(value)

dessIndentCompare column with a value or another column. Operator: lessThanprs

Parameters

sIndentvalue 
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
minusname

minus(arg)

dessIndentSubtract valueprs

Parameters

sIndentargnr to subtract
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
modname

mod(arg)

dessIndentCreate mod(arg) expressionprs

Parameters

sIndentargmod arg
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
multiplyname

multiply(arg)

dessIndentMultiply with valueprs

Parameters

sIndentargnr to multiply with
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
nullifname

nullif(arg)

dessIndentCreate nullif(arg) expressionprs

Parameters

sIndentargobject to compare
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
plusname

plus(arg)

dessIndentAdd up valueprs

Parameters

sIndentargnr to add
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
substringname

substring(pos)

dessIndentCreate substring(pos) expressionprs

Parameters

sIndentpos 
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
substringname

substring(pos, len)

dessIndentCreate substring(pos, len) expressionprs

Parameters

sIndentpos len 
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow