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.An existing foundset under that name will be returned, or created if there is a definition (there is a form with a named foundset property with that name).Get a single record from a datasource.Get the table of a datasource.get a new foundset containing records based on a dataset of pks.get a new foundset containing records based on a QBSelect query.get a new foundset containing records based on an SQL query string.get a new foundset containing records based on an SQL query string with parameters.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)
dessIndent
An existing foundset under that name will be returned, or created if there is a definition (there is a form with a named foundset property with that name).
If named foundset datasource does not match current datasource will not be returned (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
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetRecordname
getRecord(pk)
dessIndent
Get a single record from a datasource.
For the sake of performance, if more records are needed,
don't call this method in a loop but try using other methods instead.
prs
Parameters
sIndentpkThe primary key of the record to be retrieved. Can be an array, in case of a composite pk.ret
Returns
sIndent a recordclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetTablename
getTable()
dessIndent
Get the table of a datasource.
ret
Returns
sIndent JSTable tableclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowloadRecordsname
loadRecords(dataSet)
dessIndent
get a new foundset containing records based on a dataset of pks.
prs
Parameters
sIndentdataSet ;ret
Returns
sIndent a new JSFoundsetclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowloadRecordsname
loadRecords(qbSelect)
dessIndent
get a new foundset containing records based on a QBSelect query.
prs
Parameters
sIndentqbSelecta query builder objectret
Returns
sIndent a new JSFoundsetclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowloadRecordsname
loadRecords(query)
dessIndent
get a new foundset containing records based on an SQL query string.
prs
Parameters
sIndentqueryan SQL queryret
Returns
sIndent a new JSFoundsetclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowloadRecordsname
loadRecords(query, args)
dessIndent
get a new foundset containing records based on an SQL query string with parameters.
prs
Parameters
sIndentqueryan SQL query string with parameter placeholdersargsan array of arguments for the query stringret