May 21, 2024 17:32 Returns Supported Clients Sample Parameters Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients Sample Returns Supported Clients SampleSupported 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.
JSTable
getTable()
Get the table of a datasource.
Methods Details
createSelect()
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)
String
tableAlias
the table alias to use
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()
getDatasource()
datasources.db.example_data.orders.getDatasource() // returns 'db:/example_data/orders'
getFoundSet()
var fs = datasources.db.example_data.orders.getFoundSet()
var ridx = fs.newRecord()
var record = fs.getRecord(ridx)
record.emp_name = 'John'
databaseManager.saveData()
getTable()