Returns Supported Clients Sample Parameters Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Parameters Returns Supported Clients Sample Returns Supported Clients Sample
May 03, 2024 23:20Supported Clients
SmartClient
WebClient
NGClient
Methods Summary
QBSelect
createSelect()
Create a query builder for a data source.
QBSelect
createSelect(tableAlias)
Create a query builder for a data source with given table alias.
Array
getColumnNames()
Get the column names of a datasource.
String
getDataSource()
Get the datasource string.
JSFoundSet
getFoundSet()
Returns a foundset object for a specified datasource or server and tablename.
JSFoundSet
getFoundSet(name)
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).
JSTable
getTable()
Get the table of a datasource.
Methods Details
createSelect()
Create a query builder for a data source.
QBSelect
SmartClient,WebClient,NGClient
var q = datasources.db.example_data.book_nodes.createSelect()
q.result.addPk()
q.where.add(q.columns.label_text.not.isin(null))
datasources.db.example_data.book_nodes.getFoundSet().loadRecords(q)
createSelect(tableAlias)
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.
String
tableAlias
the table alias to use
QBSelect
SmartClient,WebClient,NGClient
var q = datasources.db.example_data.book_nodes.createSelect('b')
q.result.addPk()
q.where.add(q.columns.label_text.isin('select comment_text from book_text t where t.note_text = ? and t.node_id = b.node_id', ['test']))
datasources.db.example_data.book_nodes.getFoundSet().loadRecords(q)
getColumnNames()
Get the column names of a datasource.
Array
SmartClient,WebClient,NGClient
getDataSource()
Get the datasource string.
String
SmartClient,WebClient,NGClient
datasources.db.example_data.orders.getDataSource() // returns 'db:/example_data/orders'
getFoundSet()
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.
JSFoundSet
SmartClient,WebClient,NGClient
var fs = datasources.db.example_data.orders.getFoundSet()
var ridx = fs.newRecord()
var record = fs.getRecord(ridx)
record.emp_name = 'John'
databaseManager.saveData()
getFoundSet(name)
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).
String
name
The named foundset to get for this datasource.
JSFoundSet
SmartClient,WebClient,NGClient
var fs = datasources.db.example_data.orders.getFoundSet('myname')
var ridx = fs.newRecord()
var record = fs.getRecord(ridx)
record.emp_name = 'John'
databaseManager.saveData()
getTable()
Get the table of a datasource.
JSTable
SmartClient,WebClient,NGClient
Overview
Content Tools
Activity