servoy sReturnTypes 2 100% height: 30px; 2 Supported Clients sWordList SmartClient sWordList WebClient sWordList NGClient
servoy sSummary 12% 30% 58% height: 30px; 3 Property Summary Create abs(column) expression Create an ascending sort expression Create an aggregate expression. Create bit_length(column) expression Create ceil(column) expression Create an aggregate expression. Extract day from date Create an descending sort expression Create floor(column) expression Extract hour from date Compare column with null. Create length(column) expression Create lower(column) expression Create an aggregate expression. Create an aggregate expression. Extract minute from date Extract month from date Create 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) expression Extract second from date Create sqrt(column) expression Create an aggregate expression. Create trim(column) expression Create upper(column) expression Extract year from date
servoy sSummary 12% 30% 58% height: 30px; 3 Methods Summary Compare column to a range of 2 values or other columns. Create cast(column, type) expression Concatename with value Divide by value Compare column with a value or another column. Compare column with a value or another column. The flags are a bit pattern consisting of 1 or more of the following bits: - JSColumn. Column type as a string 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) expression Create locate(arg, start) expression Compare column with a value or another column. Subtract value Create mod(arg) expression Multiply with value Create nullif(arg) expression Add up value Create substring(pos) expression Create substring(pos, len) expression
property servoy sDetail 2 100% height:30px 2 Property Details abs name abs des sIndent Create abs(column) expression ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow asc name asc des sIndent Create an ascending sort expression ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow avg name avg des sIndent Create an aggregate expression. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow bit_length name bit_length des sIndent Create bit_length(column) expression ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow ceil name ceil des sIndent Create ceil(column) expression ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow count name count des sIndent Create an aggregate expression. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow day name day des sIndent Extract day from date ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow desc name desc des sIndent Create an descending sort expression ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow floor name floor des sIndent Create floor(column) expression ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow hour name hour des sIndent Extract hour from date ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow isNull name isNull des sIndent Compare column with null. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow len name len des sIndent Create length(column) expression ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow lower name lower des sIndent Create lower(column) expression ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow max name max des sIndent Create an aggregate expression. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow min name min des sIndent Create an aggregate expression. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow minute name minute des sIndent Extract minute from date ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow month name month des sIndent Extract month from date ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow not name not des sIndent Create a negated condition. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow 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 round name round des sIndent Create round(column) expression ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow second name second des sIndent Extract second from date ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow sqrt name sqrt des sIndent Create sqrt(column) expression ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow sum name sum des sIndent Create an aggregate expression. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow trim name trim des sIndent Create trim(column) expression ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow upper name upper des sIndent Create upper(column) expression ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow year name year des sIndent Extract year from date 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 between name between(value1, value2) des sIndent Compare column to a range of 2 values or other columns. prs Parameters
sIndent value1   ; value2   ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow cast name cast(type) des sIndent Create cast(column, type) expression prs Parameters
sIndent type string type, see QUERY_COLUMN_TYPES ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow concat name concat(arg) des sIndent Concatename with value prs Parameters
sIndent arg valeu to concatenate with ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow divide name divide(arg) des sIndent Divide by value prs Parameters
sIndent arg nr to divide by ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow eq name eq(value) des sIndent Compare column with a value or another column.
Operator: equals prs Parameters
sIndent value   ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow ge name ge(value) des sIndent Compare column with a value or another column.
Operator: greaterThanOrEqual prs Parameters
sIndent value   ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getFlags name getFlags() des sIndent The flags are a bit pattern consisting of 1 or more of the following bits:
- JSColumn.UUID_COLUMN
- JSColumn.EXCLUDED_COLUMN
- JSColumn.TENANT_COLUMN ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getTypeAsString name getTypeAsString() des sIndent Column type as a string ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow gt name gt(value) des sIndent Compare column with a value or another column.
Operator: greaterThan prs Parameters
sIndent value   ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow isin name isin(query) des sIndent Compare column with subquery result. prs Parameters
sIndent query subquery ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow isin name isin(values) des sIndent Compare column with values. prs Parameters
sIndent values array of values ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow isin name isin(customQuery, args) des sIndent Compare column with custom query result. prs Parameters
sIndent customQuery custom query args query arguments ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow le name le(value) des sIndent Compare column with a value or another column.
Operator: lessThanOrEqual prs Parameters
sIndent value   ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow like name like(pattern) des sIndent Compare column with a value or another column.
Operator: like prs Parameters
sIndent pattern the string value of the pattern ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow like name like(pattern, escape) des sIndent Compare column with a value or another column.
Operator: like, with escape character prs Parameters
sIndent pattern the string value of the pattern escape the escape char ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow locate name locate(arg) des sIndent Create locate(arg) expression prs Parameters
sIndent arg string to locate ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow locate name locate(arg, start) des sIndent Create locate(arg, start) expression prs Parameters
sIndent arg string to locate start start pos ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow lt name lt(value) des sIndent Compare column with a value or another column.
Operator: lessThan prs Parameters
sIndent value   ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow minus name minus(arg) des sIndent Subtract value prs Parameters
sIndent arg nr to subtract ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow mod name mod(arg) des sIndent Create mod(arg) expression prs Parameters
sIndent arg mod arg ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow multiply name multiply(arg) des sIndent Multiply with value prs Parameters
sIndent arg nr to multiply with ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow nullif name nullif(arg) des sIndent Create nullif(arg) expression prs Parameters
sIndent arg object to compare ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow plus name plus(arg) des sIndent Add up value prs Parameters
sIndent arg nr to add ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow substring name substring(pos) des sIndent Create substring(pos) expression prs Parameters
sIndent pos   ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow substring name substring(pos, len) des sIndent Create substring(pos, len) expression prs Parameters
sIndent pos   ; len   ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow