Child pages
  • QBFunctions

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 SummaryGet query builder parent table clause, this may be a query or a join clause.Get query builder parent.

servoy sSummary12%30%58%height: 30px;3Methods SummaryCreate abs(column) expressionCreate bit_length(column) expressionCast using type name.Create ceil(column) expressionCreate year(date) expressionCreate concat(args, arg2) expressionCreate day(date) expressionCreate divide(args, arg2) expressionCreate floor(column) expressionCreate hour(date) expressionCreate length(column) expressionCreate locate(str1, str2) expressionCreate locate(str1, str2, start) expressionCreate lower(column) expressionCreate minus(args, arg2) expressionCreate minute(date) expressionCreate mod(dividend, divisor) expressionCreate month(date) expressionCreate multiply(args, arg2) expressionCreate nullif(arg1, arg2) expressionCreate plus(args, arg2) expressionCreate round(column) expressionCreate second(date) expressionCreate sqrt(column) expressionCreate substring(column, pos) expressionCreate substring(column, pos, len) expressionCreate trim(column) expressionCreate trim([leading | trailing | both] [characters] from column)Create upper(column) expressionCreate year(date) expression

propertyservoy sDetail2100%height:30px2Property Detailsparentname

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
lastDetailRowrootname

root

dessIndent
Get query builder parent.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow

functionservoy sDetail2100%height:30px2Methods Detailsabsname

abs(value)

dessIndent
Create abs(column) expression
prs

Parameters

sIndentvalue ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRowbit_lengthname

bit_length(value)

dessIndent
Create bit_length(column) expression
prs

Parameters

sIndentvalue ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
castname

cast(value, type)

dessIndent
Cast using type name.
prs

Parameters

sIndentvalueobject to casttypetype see QUERY_COLUMN_TYPES
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
ceilname

ceil(arg)

dessIndent
Create ceil(column) expression
prs

Parameters

sIndentargnumber object
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
coalescename

coalesce(args)

dessIndent
Create year(date) expression
prs

Parameters

sIndentargsarguments to coalesce
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
concatname

concat(arg1, arg2)

dessIndent
Create concat(args, arg2) expression
prs

Parameters

sIndentarg1 ;arg2 ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
customname

custom(name, args)

dessIndentprs

Parameters

sIndentnamecustom function nameargsfunction arguments
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
dayname

day(arg)

dessIndent
Create day(date) expression
prs

Parameters

sIndentargdate object
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
dividename

divide(arg1, arg2)

dessIndent
Create divide(args, arg2) expression
prs

Parameters

sIndentarg1 ;arg2 ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
floorname

floor(arg)

dessIndent
Create floor(column) expression
prs

Parameters

sIndentargnumber object
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
hourname

hour(arg)

dessIndent
Create hour(date) expression
prs

Parameters

sIndentargdate object
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
lenname

len(value)

dessIndent
Create length(column) expression
prs

Parameters

sIndentvalue ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
locatename

locate(string1, string2)

dessIndent
Create locate(str1, str2) expression
prs

Parameters

sIndentstring1string to locatestring2string to search in
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
locatename

locate(string1, string2, start)

dessIndent
Create locate(str1, str2, start) expression
prs

Parameters

sIndentstring1string to locatestring2string to search instartstart pos
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
lowername

lower(value)

dessIndent
Create lower(column) expression
prs

Parameters

sIndentvalue ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
minusname

minus(arg1, arg2)

dessIndent
Create minus(args, arg2) expression
prs

Parameters

sIndentarg1 ;arg2 ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
minutename

minute(arg)

dessIndent
Create minute(date) expression
prs

Parameters

sIndentargdate object
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
modname

mod(dividend, divisor)

dessIndent
Create mod(dividend, divisor) expression
prs

Parameters

sIndentdividend ;divisor ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
monthname

month(arg)

dessIndent
Create month(date) expression
prs

Parameters

sIndentargdate object
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
multiplyname

multiply(arg1, arg2)

dessIndent
Create multiply(args, arg2) expression
prs

Parameters

sIndentarg1 ;arg2 ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
nullifname

nullif(arg1)

dessIndent
Create nullif(arg1, arg2) expression
prs

Parameters

sIndentarg1 ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
plusname

plus(arg1, arg2)

dessIndent
Create plus(args, arg2) expression
prs

Parameters

sIndentarg1 ;arg2 ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
roundname

round(arg)

dessIndent
Create round(column) expression
prs

Parameters

sIndentargnumber object
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
secondname

second(arg)

dessIndent
Create second(date) expression
prs

Parameters

sIndentargdate object
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
sqrtname

sqrt(value)

dessIndent
Create sqrt(column) expression
prs

Parameters

sIndentvalue ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
substringname

substring(arg, pos)

dessIndent
Create substring(column, pos) expression
prs

Parameters

sIndentargcolumn nameposposition
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
substringname

substring(arg, pos, len)

dessIndent
Create substring(column, pos, len) expression
prs

Parameters

sIndentargcolumn namepospositionlenlength
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
trimname

trim(value)

dessIndent
Create trim(column) expression
prs

Parameters

sIndentvalue ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
trimname

trim(leading_trailing_both, characters, fromKeyword, value)

dessIndent
Create trim([leading | trailing | both] [characters] from column)
prs

Parameters

sIndentleading_trailing_both'leading', 'trailing' or 'both'characterscharacters to removefromKeyword'from'valuevalue to trim
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
uppername

upper(value)

dessIndent
Create upper(column) expression
prs

Parameters

sIndentvalue ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
yearname

year(arg)

dessIndent
Create year(date) expression
prs

Parameters

sIndentargdate object
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow