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 second(date) expressionCreate sqrt(column) expressionCreate substring(column, pos) expressionCreate substring(column, pos, len) expressionCreate trim(column) expressionCreate 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) expressionprsParameters sIndentvalue retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow bit_lengthnamebit_length(value)dessIndentCreate bit_length(column) expressionprsParameters 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) expressionprsParameters sIndentargnumber objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow coalescenamecoalesce(args)dessIndentCreate year(date) expressionprsParameters sIndentargsarguments to coalesceretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow concatnameconcat(arg1, arg2)dessIndentCreate concat(args, arg2) expressionprsParameters sIndentarg1 arg2 retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow daynameday(arg)dessIndentCreate day(date) expressionprsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow dividenamedivide(arg1, arg2)dessIndentCreate divide(args, arg2) expressionprsParameters sIndentarg1 arg2 retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow floornamefloor(arg)dessIndentCreate floor(column) expressionprsParameters sIndentargnumber objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow hournamehour(arg)dessIndentCreate hour(date) expressionprsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow lennamelen(value)dessIndentCreate length(column) expressionprsParameters sIndentvalue retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow locatenamelocate(string1, string2)dessIndentCreate locate(str1, str2) expressionprsParameters sIndentstring1string to locatestring2string to search inretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow locatenamelocate(string1, string2, start)dessIndentCreate locate(str1, str2, start) expressionprsParameters sIndentstring1string to locatestring2string to search instartstart posretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow lowernamelower(value)dessIndentCreate lower(column) expressionprsParameters sIndentvalue retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow minusnameminus(arg1, arg2)dessIndentCreate minus(args, arg2) expressionprsParameters sIndentarg1 arg2 retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow minutenameminute(arg)dessIndentCreate minute(date) expressionprsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow modnamemod(dividend, divisor)dessIndentCreate mod(dividend, divisor) expressionprsParameters sIndentdividend divisor retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow monthnamemonth(arg)dessIndentCreate month(date) expressionprsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow multiplynamemultiply(arg1, arg2)dessIndentCreate multiply(args, arg2) expressionprsParameters sIndentarg1 arg2 retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow nullifnamenullif(arg1)dessIndentCreate nullif(arg1, arg2) expressionprsParameters sIndentarg1 retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow plusnameplus(arg1, arg2)dessIndentCreate plus(args, arg2) expressionprsParameters sIndentarg1 arg2 retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow roundnameround(arg)dessIndentCreate round(column) expressionprsParameters sIndentargnumber objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow secondnamesecond(arg)dessIndentCreate second(date) expressionprsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow sqrtnamesqrt(value)dessIndentCreate sqrt(column) expressionprsParameters sIndentvalue retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow substringnamesubstring(arg, pos)dessIndentCreate substring(column, pos) expressionprsParameters sIndentargcolumn namepospositionretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow substringnamesubstring(arg, pos, len)dessIndentCreate substring(column, pos, len) expressionprsParameters sIndentargcolumn namepospositionlenlengthretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow trimnametrim(value)dessIndentCreate trim(column) expressionprsParameters sIndentvalue retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow uppernameupper(value)dessIndentCreate upper(column) expressionprsParameters sIndentvalue retReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow yearnameyear(arg)dessIndentCreate year(date) expressionprsParameters sIndentargdate objectretReturns sIndentclientsSupported Clients sIndentSmartClient,WebClient,NGClientsamSample sIdentjavascriptlastDetailRow |