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 sIdentjavascriptlastDetailRowrootnamerootdessIndentGet query builder parent. retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowfunctionservoy sDetail2100%height:30px2Methods Detailsabsnameabs(value)dessIndentCreate abs(column) expression prsParameters sIndentvalue ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowbit_lengthnamebit_length(value)dessIndentCreate bit_length(column) expression prsParameters sIndentvalue ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowcastnamecast(value, type)dessIndentCast using type name. prsParameters sIndentvalueobject to casttypetype see QUERY_COLUMN_TYPESretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowceilnameceil(arg)dessIndentCreate ceil(column) expression prsParameters sIndentargnumber objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowcoalescenamecoalesce(args)dessIndentCreate year(date) expression prsParameters sIndentargsarguments to coalesceretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowconcatnameconcat(arg1, arg2)dessIndentCreate concat(args, arg2) expression prsParameters sIndentarg1 ;arg2 ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowcustomnamecustom(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 sIdentjavascriptlastDetailRowdividenamedivide(arg1, arg2)dessIndentCreate divide(args, arg2) expression prsParameters sIndentarg1 ;arg2 ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowfloornamefloor(arg)dessIndentCreate floor(column) expression prsParameters sIndentargnumber objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowhournamehour(arg)dessIndentCreate hour(date) expression prsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowlennamelen(value)dessIndentCreate length(column) expression prsParameters sIndentvalue ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowlocatenamelocate(string1, string2)dessIndentCreate locate(str1, str2) expression prsParameters sIndentstring1string to locatestring2string to search inretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowlocatenamelocate(string1, string2, start)dessIndentCreate locate(str1, str2, start) expression prsParameters sIndentstring1string to locatestring2string to search instartstart posretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowlowernamelower(value)dessIndentCreate lower(column) expression prsParameters sIndentvalue ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowminusnameminus(arg1, arg2)dessIndentCreate minus(args, arg2) expression prsParameters sIndentarg1 ;arg2 ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowminutenameminute(arg)dessIndentCreate minute(date) expression prsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowmodnamemod(dividend, divisor)dessIndentCreate mod(dividend, divisor) expression prsParameters sIndentdividend ;divisor ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowmonthnamemonth(arg)dessIndentCreate month(date) expression prsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowmultiplynamemultiply(arg1, arg2)dessIndentCreate multiply(args, arg2) expression prsParameters sIndentarg1 ;arg2 ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRownullifnamenullif(arg1)dessIndentCreate nullif(arg1, arg2) expression prsParameters sIndentarg1 ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowplusnameplus(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 sIdentjavascriptlastDetailRowroundnameround(arg, decimals)dessIndentCreate round(column) expression prsParameters sIndentargnumber objectdecimalsThe number of decimal places to round number to, default 0retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowsecondnamesecond(arg)dessIndentCreate second(date) expression prsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowsqrtnamesqrt(value)dessIndentCreate sqrt(column) expression prsParameters sIndentvalue ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowsubstringnamesubstring(arg, pos)dessIndentCreate substring(column, pos) expression prsParameters sIndentargcolumn namepospositionretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowsubstringnamesubstring(arg, pos, len)dessIndentCreate substring(column, pos, len) expression prsParameters sIndentargcolumn namepospositionlenlengthretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowtrimnametrim(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 sIdentjavascriptlastDetailRowuppernameupper(value)dessIndentCreate upper(column) expression prsParameters sIndentvalue ;retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRowyearnameyear(arg)dessIndentCreate year(date) expression prsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow |