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 an AND-condition to add conditions to. Get all the columns of the datasource that can be used for this query (select or where clause) Get the functions clause from a query, used for functions that are not tied to a column. Get the group by clause from a query Get the having-part of the query, used to add conditions. Get the joins clause of this table based clause. Create an OR-condition to add conditions to. Get the named parameters from a query. Get query builder parent table clause, this may be a query or a join clause. Get the result part of the query, used to add result columns or values. Get query builder parent. Get the sorting part of the query. Get the where-part of the query, used to add conditions.
servoy sSummary 12% 30% 58% height: 30px; 3 Methods Summary Clear the having-part of the query. Get an exists-condition from a subquery Get a column from the table. Get a column from the table with given alias. Returns the datasource for this. Get or create a parameter for the query, this used to parameterize queries. Returns the table alias for this. Create an negated condition. Create an negated condition.
property servoy sDetail 2 100% height:30px 2 Property Details and name and des sIndent Create an AND-condition to add conditions to. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow columns name columns des sIndent Get all the columns of the datasource that can be used for this query (select or where clause) ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow functions name functions des sIndent Get the functions clause from a query, used for functions that are not tied to a column. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow groupBy name groupBy des sIndent Get the group by clause from a query ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow having name having des sIndent Get the having-part of the query, used to add conditions.
The conditions added here are AND-ed. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow joins name joins des sIndent Get the joins clause of this table based clause.
Joins added to this clause will be based on this table clauses table. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow or name or des sIndent Create an OR-condition to add conditions to. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow params name params des sIndent Get the named parameters from a query. 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 result name result des sIndent Get the result part of the query, used to add result columns or values. 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 sort name sort des sIndent Get the sorting part of the query. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow where name where des sIndent Get the where-part of the query, used to add conditions.
The conditions added here are AND-ed. 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 clearHaving name clearHaving() des sIndent Clear the having-part of the query. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow exists name exists(query) des sIndent Get an exists-condition from a subquery prs Parameters
sIndent query the sub query ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getColumn name getColumn(name) des sIndent Get a column from the table. prs Parameters
sIndent name the name of column to get ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getColumn name getColumn(columnTableAlias, name) des sIndent Get a column from the table with given alias.
The alias may be of the main table or any level deep joined table. prs Parameters
sIndent columnTableAlias the alias for the table name the name of column to get ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getDataSource name getDataSource() des sIndent Returns the datasource for this. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getParameter name getParameter(name) des sIndent Get or create a parameter for the query, this used to parameterize queries. prs Parameters
sIndent name the name of the parameter ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getTableAlias name getTableAlias() des sIndent Returns the table alias for this. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow not name not(cond) des sIndent Create an negated condition. prs Parameters
sIndent cond the condition to negate ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow not name not(cond) des sIndent Create an negated condition. prs Parameters
sIndent cond the logical condition to negate ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow