servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientservoy 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 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) expressionpropertyservoy sDetail2100%height:30px2Property DetailsparentnameparentdessIndentGet query builder parent table clause, this may be a query or a join clause. retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow rootnamerootdessIndentGet query builder parent. retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow functionservoy sDetail2100%height:30px2Methods Detailsabsnameabs(value)dessIndentCreate abs(column) expression prsParameters sIndentvalue  ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow bit_lengthnamebit_length(value)dessIndentCreate bit_length(column) expression prsParameters sIndentvalue  ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow castnamecast(value, type)dessIndentCast using type name. prsParameters sIndentvalueobject to casttypetype see QUERY_COLUMN_TYPESretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow ceilnameceil(arg)dessIndentCreate ceil(column) expression prsParameters sIndentargnumber objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow coalescenamecoalesce(args)dessIndentCreate year(date) expression prsParameters sIndentargsarguments to coalesceretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow concatnameconcat(arg1, arg2)dessIndentCreate concat(args, arg2) expression prsParameters sIndentarg1  ;arg2  ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow customnamecustom(name, args)dessIndentprsParameters sIndentnamecustom function nameargsfunction argumentsretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowdaynameday(arg)dessIndentCreate day(date) expression prsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow dividenamedivide(arg1, arg2)dessIndentCreate divide(args, arg2) expression prsParameters sIndentarg1  ;arg2  ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow floornamefloor(arg)dessIndentCreate floor(column) expression prsParameters sIndentargnumber objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow hournamehour(arg)dessIndentCreate hour(date) expression prsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow lennamelen(value)dessIndentCreate length(column) expression prsParameters sIndentvalue  ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow locatenamelocate(string1, string2)dessIndentCreate locate(str1, str2) expression prsParameters sIndentstring1string to locatestring2string to search inretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow locatenamelocate(string1, string2, start)dessIndentCreate locate(str1, str2, start) expression prsParameters sIndentstring1string to locatestring2string to search instartstart posretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow lowernamelower(value)dessIndentCreate lower(column) expression prsParameters sIndentvalue  ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow minusnameminus(arg1, arg2)dessIndentCreate minus(args, arg2) expression prsParameters sIndentarg1  ;arg2  ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow minutenameminute(arg)dessIndentCreate minute(date) expression prsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow modnamemod(dividend, divisor)dessIndentCreate mod(dividend, divisor) expression prsParameters sIndentdividend  ;divisor  ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow monthnamemonth(arg)dessIndentCreate month(date) expression prsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow multiplynamemultiply(arg1, arg2)dessIndentCreate multiply(args, arg2) expression prsParameters sIndentarg1  ;arg2  ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow nullifnamenullif(arg1)dessIndentCreate nullif(arg1, arg2) expression prsParameters sIndentarg1  ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow plusnameplus(arg1, arg2)dessIndentCreate plus(args, arg2) expression prsParameters sIndentarg1  ;arg2 ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowroundnameround(arg)dessIndentCreate round(column) expression prsParameters sIndentargnumber objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow roundnameround(arg, decimals)dessIndentCreate round(column) expression prsParameters sIndentargnumber objectdecimalsThe number of decimal places to round number to, default 0retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow secondnamesecond(arg)dessIndentCreate second(date) expression prsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow sqrtnamesqrt(value)dessIndentCreate sqrt(column) expression prsParameters sIndentvalue  ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow substringnamesubstring(arg, pos)dessIndentCreate substring(column, pos) expression prsParameters sIndentargcolumn namepospositionretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow substringnamesubstring(arg, pos, len)dessIndentCreate substring(column, pos, len) expression prsParameters sIndentargcolumn namepospositionlenlengthretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow trimnametrim(value)dessIndentCreate trim(column) expression prsParameters sIndentvalue ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowtrimnametrim(leading_trailing_both, characters, fromKeyword, value)dessIndentCreate trim([leading | trailing | both] [characters] from column) prsParameters sIndentleading_trailing_both'leading', 'trailing' or 'both'characterscharacters to removefromKeyword'from'valuevalue to trimretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow uppernameupper(value)dessIndentCreate upper(column) expression prsParameters sIndentvalue  ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow yearnameyear(arg)dessIndentCreate year(date) expression prsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow |