servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientservoy sSummary12%30%58%height: 30px;3Property SummaryCreate abs(column) expressionCreate an ascending sort expressionCreate an aggregate expression.Create bit_length(column) expressionCreate ceil(column) expressionCreate an aggregate expression.Extract day from dateCreate an descending sort expressionCreate floor(column) expressionExtract hour from dateCompare column with null.Create length(column) expressionCreate lower(column) expressionCreate an aggregate expression.Create an aggregate expression.Extract minute from dateExtract month from dateCreate a negated condition.Get query builder parent table clause, this may be a query or a join clause.Get query builder parent.Create round(column) expressionExtract second from dateCreate sqrt(column) expressionCreate an aggregate expression.Create trim(column) expressionCreate upper(column) expressionExtract year from dateservoy sSummary12%30%58%height: 30px;3Methods SummaryCompare column to a range of 2 values or other columns.Create cast(column, type) expressionConcatename with valueDivide by valueCompare column with a value or another column.Compare column with a value or another column.Compare column with a value or another column.Compare column with subquery result.Compare column with values.Compare column with custom query result.Compare column with a value or another column.Compare column with a value or another column.Compare column with a value or another column.Create locate(arg) expressionCreate locate(arg, start) expressionCompare column with a value or another column.Subtract valueCreate mod(arg) expressionMultiply with valueCreate nullif(arg) expressionAdd up valueCreate substring(pos) expressionCreate substring(pos, len) expressionpropertyservoy sDetail2100%height:30px2Property Detailsabsname
abs
dessIndentCreate abs(column) expressionret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow ascname
asc
dessIndentCreate an ascending sort expressionret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow avgname
avg
dessIndentCreate an aggregate expression.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow bit_lengthname
bit_length
dessIndentCreate bit_length(column) expressionret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow ceilname
ceil
dessIndentCreate ceil(column) expressionret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow countname
count
dessIndentCreate an aggregate expression.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow dayname
day
dessIndentExtract day from dateret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow descname
desc
dessIndentCreate an descending sort expressionret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow floorname
floor
dessIndentCreate floor(column) expressionret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow hourname
hour
dessIndentExtract hour from dateret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow isNullname
isNull
dessIndentCompare column with null.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow lenname
len
dessIndentCreate length(column) expressionret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow lowername
lower
dessIndentCreate lower(column) expressionret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow maxname
max
dessIndentCreate an aggregate expression.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow minname
min
dessIndentCreate an aggregate expression.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow minutename
minute
dessIndentExtract minute from dateret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow monthname
month
dessIndentExtract month from dateret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow notname
not
dessIndentCreate a negated condition.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow parentname
parent
dessIndentGet query builder parent table clause, this may be a query or a join clause.ret