servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientservoy sSummary12%30%58%height: 30px;3Methods SummaryCreate a query builder for a data source.Create a query builder for a data source with given table alias.Get the column names of a datasource.Get the datasource string.Returns a foundset object for a specified datasource or server and tablename.Returns An existing foundset under that name will be returned, or created if there is a definition (there is a form with a named foundset object for a specified nameproperty with that name).Get the table of a datasource.functionservoy sDetail2100%height:30px2Methods DetailscreateSelectname
createSelect()
dessIndent
Create a query builder for a data source.
ret
Returns
sIndent query builderclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowcreateSelectname
createSelect(tableAlias)
dessIndent
Create a query builder for a data source with given table alias.
The alias can be used inside custom queries to bind to the outer table.
prs
Parameters
sIndenttableAliasthe table alias to useret
Returns
sIndent query builderclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetColumnNamesname
getColumnNames()
dessIndent
Get the column names of a datasource.
ret
Returns
sIndent String[] column namesclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetDataSourcename
getDataSource()
dessIndent
Get the datasource string.
ret
Returns
sIndent String datasourceclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetFoundSetname
getFoundSet()
dessIndent
Returns a foundset object for a specified datasource or server and tablename.
It is important to note that this is a FACTORY method, it constantly creates new foundsets.
ret
Returns
sIndent A new JSFoundset for the datasource.clients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetFoundSetname
getFoundSet(name)
dessIndentReturns
An existing foundset under that name will be returned, or created if there is a definition (there is a form with a named foundset
object
property
for
with
a
that
specified
name).
If named foundset datasource does not match current datasource will not be returned
.
If named foundset is not created
(will return null instead).
prs
Parameters
sIndentnameThe named foundset to get for this datasource.ret
Returns
sIndent An existing named foundset for the datasource.clients