servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientservoy sSummary12%30%58%height: 30px;3Property SummaryGet/set the distinct flag for the query.Get 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 SummaryAdd an aggregate to the query result.Add an aggregate with alias to the query result.Add a column to the query result.Add a column with alias to the query result.Add a function result to the query result.Add a function with alias result to the query result.Add the tables' primary pk columns in alphabetical order to the query result.Add a query to the query result.Add a query with alias to the query result.Add a custom subquery to the query result.Add a custom subquery with alias to the query result.Add a value to the query result.Add a value with an alias to the query result.Clear the columns in the query result.returns an array with all the columns that will be in the select of this query.propertyservoy sDetail2100%height:30px2Property Detailsdistinctname
distinct
dessIndentGet/set the distinct flag for the 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
dessIndentAdd a custom subquery with alias to the query result.prs
Parameters
sIndentcustomQueryquery to add to resultargsarguments to the queryaliasresult aliasret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow addValuename
addValue(value)
dessIndentAdd a value to the query result.prs
Parameters
sIndentvaluevalue add to resultret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow addValuename
addValue(value, alias)
dessIndentAdd a value with an alias to the query result.prs
Parameters
sIndentvaluevalue add to resultaliasvalue aliasret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow clearname
clear()
dessIndentClear the columns in the query result.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow getColumnsname
getColumns()
dessIndentreturns an array with all the columns that will be in the select of this query. can return empty array. Then the system will auto append the pk when this query is used.ret