servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientservoy sSummary12%30%58%height: 30px;3Property SummaryCreate 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 queryGet 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 sSummary12%30%58%height: 30px;3Methods SummaryClear the having-part of the query.Get an exists-condition from a subqueryGet 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.propertyservoy sDetail2100%height:30px2Property Detailsandname
and
dessIndentCreate an AND-condition to add conditions to.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow columnsname
columns
dessIndentGet all the columns of the datasource that can be used for this query (select or where clause)ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow functionsname
functions
dessIndentGet the functions clause from a query, used for functions that are not tied to a column.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow groupByname
groupBy
dessIndentGet the group by clause from a queryret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow havingname
having
dessIndentGet the having-part of the query, used to add conditions. The conditions added here are AND-ed.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow joinsname
joins
dessIndentGet the joins clause of this table based clause. Joins added to this clause will be based on this table clauses table.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow orname
or
dessIndentCreate an OR-condition to add conditions to.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow paramsname
params
dessIndentGet the named parameters from a query.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
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow resultname
result
dessIndentGet the result part of the query, used to add result columns or values.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow rootname
root
dessIndentGet query builder parent.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow sortname
sort
dessIndentGet the sorting part of the query.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow wherename
where
dessIndentGet the where-part of the query, used to add conditions. The conditions added here are AND-ed.ret