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
dessIndent
Get/set the distinct flag for the query.
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowparentname
parent
dessIndent
Get query builder parent table clause, this may be a query or a join clause.
sIndentaggregatethe aggregate to add to resultaliasaggregate aliasret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddname
add(column)
dessIndent
Add a column to the query result.
prs
Parameters
sIndentcolumncolumn to add to resultret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddname
add(column, alias)
dessIndent
Add a column with alias to the query result.
prs
Parameters
sIndentcolumncolumn to add to resultaliascolumn aliasret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddname
add(func)
dessIndent
Add a function result to the query result.
prs
Parameters
sIndentfuncthe function to add to the resultret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddname
add(func, alias)
dessIndent
Add a function with alias result to the query result.
prs
Parameters
sIndentfuncthe function to add to the resultaliasfunction aliasret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddPkname
addPk()
dessIndent
Add the tables' primary pk columns in alphabetical order to the query result.
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddSubSelectname
addSubSelect(query)
dessIndent
Add a query to the query result.
prs
Parameters
sIndentqueryquery to add to resultret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddSubSelectname
addSubSelect(query, alias)
dessIndent
Add a query with alias to the query result.
prs
Parameters
sIndentqueryquery to add to resultaliasresult aliasret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddSubSelectname
addSubSelect(customQuery, args)
dessIndent
Add a custom subquery to the query result.
prs
Parameters
sIndentcustomQueryquery to add to resultargsarguments to the queryret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddSubSelectname
addSubSelect(customQuery, args, alias)
dessIndent
Add 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
sIdentjavascriptlastDetailRowaddValuename
addValue(value)
dessIndent
Add a value to the query result.
prs
Parameters
sIndentvaluevalue add to resultret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowaddValuename
addValue(value, alias)
dessIndent
Add a value with an alias to the query result.
prs
Parameters
sIndentvaluevalue add to resultaliasvalue aliasret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowclearname
clear()
dessIndent
Clear the columns in the query result.
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetColumnsname
getColumns()
dessIndent
returns 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.