Create length(column) expression Create locate(str1, str2) expression Create locate(str1, str2, start) expression Create lower(column) expression Create minus(args, arg2) expression Create minute(date) expression Create mod(dividend, divisor) expression Create month(date) expression Create multiply(args, arg2) expression Create nullif(arg1, arg2) expression Create plus(args, arg2) expression Create round(column) expression Create round(column) expression Create second(date) expression Create sqrt(column) expression Create substring(column, pos) expression Create substring(column, pos, len) expression Create trim(column) expression Create trim([leading | trailing | both] [characters] from column) Create upper(column) expression Create year(date) expression
property servoy sDetail 2 100% height:30px 2 Property Details parent name parent des sIndent Get query builder parent table clause, this may be a query or a join clause. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow root name root des sIndent Get query builder parent. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow
function servoy sDetail 2 100% height:30px 2 Methods Details abs name abs(value) des sIndent Create abs(column) expression prs Parameters
sIndent value ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow bit_length name bit_length(value) des sIndent Create bit_length(column) expression prs Parameters
sIndent value ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow cast name cast(value, type) des sIndent Cast using type name. prs Parameters
sIndent value object to cast type type see QUERY_COLUMN_TYPES ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow ceil name ceil(arg) des sIndent Create ceil(column) expression prs Parameters
sIndent arg number object ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow coalesce name coalesce(args) des sIndent Create year(date) expression prs Parameters
sIndent args arguments to coalesce ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow concat name concat(arg1, arg2) des sIndent Create concat(args, arg2) expression prs Parameters
sIndent arg1 ; arg2 ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow custom name custom(name, args) des sIndent prs Parameters
sIndent name custom function name args function arguments ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow day name day(arg) des sIndent Create day(date) expression prs Parameters
sIndent arg date object ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow divide name divide(arg1, arg2) des sIndent Create divide(args, arg2) expression prs Parameters
sIndent arg1 ; arg2 ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow floor name floor(arg) des sIndent Create floor(column) expression prs Parameters
sIndent arg number object ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow hour name hour(arg) des sIndent Create hour(date) expression prs Parameters
sIndent arg date object ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow len name len(value) des sIndent Create length(column) expression prs Parameters
sIndent value ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow locate name locate(string1, string2) des sIndent Create locate(str1, str2) expression prs Parameters
sIndent string1 string to locate string2 string to search in ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow locate name locate(string1, string2, start) des sIndent Create locate(str1, str2, start) expression prs Parameters
sIndent string1 string to locate string2 string to search in start start pos ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow lower name lower(value) des sIndent Create lower(column) expression prs Parameters
sIndent value ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow minus name minus(arg1, arg2) des sIndent Create minus(args, arg2) expression prs Parameters
sIndent arg1 ; arg2 ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow minute name minute(arg) des sIndent Create minute(date) expression prs Parameters
sIndent arg date object ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow mod name mod(dividend, divisor) des sIndent Create mod(dividend, divisor) expression prs Parameters
sIndent dividend ; divisor ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow month name month(arg) des sIndent Create month(date) expression prs Parameters
sIndent arg date object ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow multiply name multiply(arg1, arg2) des sIndent Create multiply(args, arg2) expression prs Parameters
sIndent arg1 ; arg2 ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow nullif name nullif(arg1) des sIndent Create nullif(arg1, arg2) expression prs Parameters
sIndent arg1 ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow plus name plus(arg1, arg2) des sIndent Create plus(args, arg2) expression prs Parameters
sIndent arg1 ; arg2 ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow round name round(arg) des sIndent Create round(column) expression prs Parameters
sIndent arg number object ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow round name round(arg, decimals) des sIndent Create round(column) expression prs Parameters
sIndent arg number object decimals The number of decimal places to round number to, default 0 ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow second name second(arg) des sIndent Create second(date) expression prs Parameters
sIndent arg date object ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow sqrt name sqrt(value) des sIndent Create sqrt(column) expression prs Parameters
sIndent value ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow substring name substring(arg, pos) des sIndent Create substring(column, pos) expression prs Parameters
sIndent arg column name pos position ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow substring name substring(arg, pos, len) des sIndent Create substring(column, pos, len) expression prs Parameters
sIndent arg column name pos position len length ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow trim name trim(value) des sIndent Create trim(column) expression prs Parameters
sIndent value ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow trim name trim(leading_trailing_both, characters, fromKeyword, value) des sIndent Create trim([leading | trailing | both] [characters] from column) prs Parameters
sIndent leading_trailing_both 'leading', 'trailing' or 'both' characters characters to remove fromKeyword 'from' value value to trim ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow upper name upper(value) des sIndent Create upper(column) expression prs Parameters
sIndent value ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow year name year(arg) des sIndent Create year(date) expression prs Parameters
sIndent arg date object ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow