Child pages
  • QBResult

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Cache
indextrue
refresh100d
showRefreshtrue
iddoc
titleRefresh page
showDatetrue
retryEnable

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy 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

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow parentname

parent

dessIndentGet query builder parent table clause, this may be a query or a join clause.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
rootname

root

dessIndentGet query builder parent.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 

functionservoy sDetail2100%height:30px2Methods Detailsaddname

add(aggregate)

dessIndentAdd an aggregate to the query result.prs

Parameters

sIndentaggregatethe aggregate to add to result
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow addname

add(aggregate, alias)

dessIndentAdd an aggregate with alias to the query result.prs

Parameters

sIndentaggregatethe aggregate to add to resultaliasaggregate alias
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
addname

add(column)

dessIndentAdd a column to the query result.prs

Parameters

sIndentcolumncolumn to add to result
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
addname

add(column, alias)

dessIndentAdd a column with alias to the query result.prs

Parameters

sIndentcolumncolumn to add to resultaliascolumn alias
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
addname

add(func)

dessIndentAdd a function result to the query result.prs

Parameters

sIndentfuncthe function to add to the result
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
addname

add(func, alias)

dessIndentAdd a function with alias result to the query result.prs

Parameters

sIndentfuncthe function to add to the resultaliasfunction alias
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
addPkname

addPk()

dessIndentAdd the tables' primary pk columns in alphabetical order to the query result.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
addSubSelectname

addSubSelect(query)

dessIndentAdd a query to the query result.prs

Parameters

sIndentqueryquery to add to result
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
addSubSelectname

addSubSelect(query, alias)

dessIndentAdd a query with alias to the query result.prs

Parameters

sIndentqueryquery to add to resultaliasresult alias
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
addSubSelectname

addSubSelect(customQuery, args)

dessIndentAdd a custom subquery to the query result.prs

Parameters

sIndentcustomQueryquery to add to resultargsarguments to the query
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
addSubSelectname

addSubSelect(customQuery, args, alias)

dessIndentAdd a custom subquery with alias to the query result.prs

Parameters

sIndentcustomQueryquery to add to resultargsarguments to the queryaliasresult alias
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
addValuename

addValue(value)

dessIndentAdd a value to the query result.prs

Parameters

sIndentvaluevalue add to result
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
addValuename

addValue(value, alias)

dessIndentAdd a value with an alias to the query result.prs

Parameters

sIndentvaluevalue add to resultaliasvalue alias
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
clearname

clear()

dessIndentClear the columns in the query result.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
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

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow