Child pages
  • QBSelect

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

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow columnsname

columns

dessIndentGet all the columns of the datasource that can be used for this query (select or where clause)ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
functionsname

functions

dessIndentGet the functions clause from a query, used for functions that are not tied to a column.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
groupByname

groupBy

dessIndentGet the group by clause from a queryret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
havingname

having

dessIndentGet the having-part of the query, used to add conditions. The conditions added here are AND-ed.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

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

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
orname

or

dessIndentCreate an OR-condition to add conditions to.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
paramsname

params

dessIndentGet the named parameters from a 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 
resultname

result

dessIndentGet the result part of the query, used to add result columns or values.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 
sortname

sort

dessIndentGet the sorting part of the query.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
wherename

where

dessIndentGet the where-part of the query, used to add conditions. The conditions added here are AND-ed.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 

functionservoy sDetail2100%height:30px2Methods DetailsclearHavingname

clearHaving()

dessIndentClear the having-part of the query.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow existsname

exists(query)

dessIndentGet an exists-condition from a subqueryprs

Parameters

sIndentquerythe sub query
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
getColumnname

getColumn(name)

dessIndentGet a column from the table.prs

Parameters

sIndentnamethe name of column to get
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
getColumnname

getColumn(columnTableAlias, name)

dessIndentGet a column from the table with given alias. The alias may be of the main table or any level deep joined table.prs

Parameters

sIndentcolumnTableAliasthe alias for the tablenamethe name of column to get
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
getDataSourcename

getDataSource()

dessIndentReturns the datasource for this.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
getParametername

getParameter(name)

dessIndentGet or create a parameter for the query, this used to parameterize queries.prs

Parameters

sIndentnamethe name of the parameter
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
getTableAliasname

getTableAlias()

dessIndentReturns the table alias for this.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
notname

not(cond)

dessIndentCreate an negated condition.prs

Parameters

sIndentcondthe condition to negate
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
notname

not(cond)

dessIndentCreate an negated condition.prs

Parameters

sIndentcondthe logical condition to negate
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow