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 a named foundset object for a specified name.Get the table of a datasource.functionservoy sDetail2100%height:30px2Methods DetailscreateSelectname
createSelect()
dessIndent
Create a query builder for a data source.
ret
Returns
sIndentquery 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
sIndentquery builderclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetColumnNamesname
getColumnNames()
dessIndent
Get the column names of a datasource.
ret
Returns
sIndentString[] column namesclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetDataSourcename
getDataSource()
dessIndent
Get the datasource string.
ret
Returns
sIndentString 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
sIndentA new JSFoundset for the datasource.clients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetFoundSetname
getFoundSet(name)
dessIndent
Returns a named foundset object for a specified name. If named foundset datasource does not match current datasource will not be returned.
If named foundset is not created will return null.
prs
Parameters
sIndentnameThe named foundset to get for this datasource.ret
Returns
sIndentAn existing named foundset for the datasource.clients