Table Row (tr) |
---|
| Table Head (th) |
---|
| Method Details |
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
acquireLock |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| acquireLock |
Span |
---|
| (foundset, record_index, [lock_name]) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Request lock(s) for a foundset, can be a normal or related foundset. The record_index can be -1 to lock all rows, 0 to lock the current row, or a specific row of > 0 Optionally name the lock(s) so that it can be referenced it in releaseAllLocks() returns true if the lock could be acquired. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters foundset – The JSFoundset to get the lock for record_index – The record index which should be locked. [lock_name] – The name of the lock. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if the lock could be acquired. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//locks the complete foundset
databaseManager.acquireLock(foundset,-1);
//locks the current row
databaseManager.acquireLock(foundset,0);
//locks all related orders for the current Customer
var success = databaseManager.acquireLock(Cust_to_Orders,-1);
if(!success)
{
plugins.dialogs.showWarningDialog('Alert','Failed to get a lock','OK');
}
|
|
|
|
|
Table Body (tbody) |
---|
id | addTableFilterParam |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
addTableFilterParam |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| addTableFilterParam |
Span |
---|
| (server_name, table_name, dataprovider, operator, value, [filter_name]) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Adds a filter to all the foundsets based on a table. Note: if null is provided as the tablename the filter will be applied on all tables with the dataprovider name returns true if the tablefilter could be applied. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters server_name – The name of the database server connection for the specified table name. table_name – The name of the specified table. dataprovider – A specified dataprovider column name. operator – One of "=, <, >, >=, <=, !=, LIKE, or IN". value – The specified filter value. [filter_name] – The specified name of the database table filter. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if the tablefilter could be applied. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//best way to call this in a global solution startup method
var success = databaseManager.addTableFilterParam('admin', 'messages', 'messagesid', '>', 10, 'higNumberedMessagesRule')
|
|
|
|
|
Table Body (tbody) |
---|
id | commitTransaction |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
commitTransaction |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| commitTransaction |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns true if a transaction is committed; rollback if commit fails. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – if the transaction could be committed. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
// starts a database transaction
databaseManager.startTransaction()
//Now let users input data
//when data has been entered do a commit or rollback if the data entry is canceld or the the commit did fail.
if (cancel || !databaseManager.commitTransaction())
{
databaseManager.rollbackTransaction();
}
|
|
|
|
|
Table Body (tbody) |
---|
id | convertFoundSet |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
convertFoundSet |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| JSFoundset |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| convertFoundSet |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Creates a foundset that combines all the records of the specified one-to-many relation seen from the given parent/primary foundset. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {Object} foundset – The JSFoundset to convert. {Object} relation – can be a one-to-many relation object or the name of a one-to-many relation |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns JSFoundset – The converted JSFoundset. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
// Convert in the order form a orders foundset into a orderdetails foundset,
// that has all the orderdetails from all the orders in the foundset.
var convertedFoundSet = databaseManager.convertFoundSet(foundset,order_to_orderdetails);
// or var convertedFoundSet = databaseManager.convertFoundSet(foundset,"order_to_orderdetails");
forms.orderdetails.controller.showRecords(convertedFoundSet);
|
|
|
|
|
Table Body (tbody) |
---|
id | convertToDataSet |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
convertToDataSet |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| JSDataSet |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| convertToDataSet |
Span |
---|
| (array/ids_string/foundset, [array_with_dataprovider_names]) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Converts the argument to a JSDataSet, possible use in controller.loadRecords(dataset) |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters array/ids_string/foundset – The data that should go into the JSDataSet. [array_with_dataprovider_names] – Array with column names. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns JSDataSet – JSDataSet with the data. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
// converts a foundset pks to a dataset
var dataset = databaseManager.convertToDataSet(foundset);
// converts a foundset to a dataset
//var dataset = databaseManager.convertToDataSet(foundset,['product_id','product_name']);
// converts an object array to a dataset
//var dataset = databaseManager.convertToDataSet(files,['name','path']);
// converts an array to a dataset
//var dataset = databaseManager.convertToDataSet(new Array(1,2,3,4,5,6));
// converts an string list to a dataset
//var dataset = databaseManager.convertToDataSet('4,5,6');
|
|
|
|
|
Table Body (tbody) |
---|
id | copyMatchingColumns |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
copyMatchingColumns |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| copyMatchingColumns |
Span |
---|
| (src_record, dest_record, [overwrite/array_of_names_not_overwritten]) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Copies all matching non empty columns (if overwrite boolean is given all columns except pk/ident, if array then all columns except pk and array names). returns true if no error did happen. NOTE: This function could be used to store a copy of records in an archive table. Use the getRecord() function to get the record as an object. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters src_record – The source record to be copied. dest_record – The destination record to copy to. [overwrite/array_of_names_not_overwritten] – true (default false) if everything can be overwritten or an array of names that shouldnt be overwritten. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if no errors happend. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
for( var i = 1 ; i <= foundset.getSize() ; i++ )
{
var srcRecord = foundset.getRecord(i);
var destRecord = otherfoundset.getRecord(i);
if (srcRecord == null || destRecord == null) break;
databaseManager.copyMatchingColumns(srcRecord,destRecord,true)
}
//saves any outstanding changes to the dest foundset
controller.saveData();
|
|
|
|
|
Table Body (tbody) |
---|
id | createEmptyDataSet |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
createEmptyDataSet |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| JSDataSet |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| createEmptyDataSet |
Span |
---|
| (row_count, columnCount/array_with_column_names) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns an empty dataset object. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters row_count – The number of rows in the DataSet object. columnCount/array_with_column_names – Number of columns or the column names. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns JSDataSet – An empty JSDataSet with the initial sizes. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
// gets an empty dataset with a specifed row and column count
var dataset = databaseManager.createEmptyDataSet(10,10)
// gets an empty dataset with a specifed row count and column array
var dataset2 = databaseManager.createEmptyDataSet(10,new Array ('a','b','c','d'))
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getAutoSave |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getAutoSave |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns true or false if autosave is enabled or disabled. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if autosave if enabled. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//Set autosave, if false then no saves will happen by the ui (not including deletes!). Until you call saveData or setAutoSave(true)
//Rollbacks in mem the records that were edited and not yet saved. Best used in combination with autosave false.
databaseManager.setAutoSave(false)
//Now let users input data
//On save or cancel, when data has been entered:
if (cancel) databaseManager.rollbackEditedRecords()
databaseManager.setAutoSave(true)
|
|
|
|
|
Table Body (tbody) |
---|
id | getDataSetByQuery |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getDataSetByQuery |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| JSDataSet |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getDataSetByQuery |
Span |
---|
| (server_name, sql_query, arguments, max_returned_rows) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Performs a sql query on the specified server, returns the result in a dataset. Will throw an exception if anything did go wrong when executing the query. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {String} server_name – The name of the server where the query should be executed. {String} sql_query – The custom sql. {Object[]} arguments – Specified arguments or null if there are no arguments. {Number} max_returned_rows – The maximum number of rows returned by the query. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns JSDataSet – The JSDataSet containing the results of the query. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//finds duplicate records in a specified foundset
var vQuery =" SELECT companiesid from companies where company_name IN (SELECT company_name from companies group bycompany_name having count(company_name)>1 )";
var vDataset =databaseManager.getDataSetByQuery(databaseManager.getDataSourceServerName(controller.getDataSource()), vQuery, null, 1000);
controller.loadRecords(vDataset);
var maxReturnedRows = 10;//useful to limit number of rows
var query = 'select c1,c2,c3 from test_table where start_date = ?';//do not use '.' or special chars in names or aliases if you want to access data by name
var args = new Array();
args[0] = order_date //or new Date()
var dataset = databaseManager.getDataSetByQuery(databaseManager.getDataSourceServerName(controller.getDataSource()), query, args, maxReturnedRows);
// place in label:
// elements.myLabel.text = '<html>'+dataset.getAsHTML()+'</html>';
//example to calc a strange total
global_total = 0;
for( var i = 1 ; i <= dataset.getMaxRowIndex() ; i++ )
{
dataset.rowIndex = i;
global_total = global_total + dataset.c1 + dataset.getValue(i,3);
}
//example to assign to dataprovider
//employee_salary = dataset.getValue(row,column)
|
|
|
|
|
Table Body (tbody) |
---|
id | getDataSourceServerName |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getDataSourceServerName |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getDataSourceServerName |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns the server name from the datasource, or null if not a database datasource. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {String} dataSource – The datasource string to get the server name from. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String – The servername of the datasource. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var servername = databaseManager.getDataSourceServerName(datasource);
|
|
|
|
|
Table Body (tbody) |
---|
id | getDataSourceTableName |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getDataSourceTableName |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getDataSourceTableName |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns the table name from the datasource, or null if not a database datasource. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {String} dataSource – The datasource string to get the tablename from. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String – The tablename of the datasource. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var tablename = databaseManager.getDataSourceTableName(datasource);
|
|
|
|
|
Table Body (tbody) |
---|
id | getDatabaseProductName |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getDatabaseProductName |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getDatabaseProductName |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns the database product name as supplied by the driver for a server. NOTE: For more detail on named server connections, see the chapter on Database Connections, beginning with the Introduction to database connections in the Servoy Developer User's Guide. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {String} serverName – The specified name of the database server connection. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String – A database product name. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var databaseProductName = databaseManager.getDatabaseProductName(servername)
|
|
|
|
|
Table Body (tbody) |
---|
id | getEditedRecords |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getEditedRecords |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| JSRecord[] |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getEditedRecords |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns an array of edited records with outstanding (unsaved) data. NOTE: To return a dataset of outstanding (unsaved) edited data for each record, see JSRecord.getChangedData(); NOTE2: The fields focus may be lost in user interface in order to determine the edits. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns JSRecord[] – Array of outstanding/unsaved JSRecords. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//This method can be used to loop through all outstanding changes,
//the application.output line contains all the changed data, their tablename and primary key
var editr = databaseManager.getEditedRecords()
for (x=0;x<editr.length;x++)
{
var ds = editr[x].getChangedData();
var jstable = databaseManager.getTable(editr[x]);
var tableSQLName = jstable.getSQLName();
var pkrec = jstable.getRowIdentifierColumnNames().join(',');
var pkvals = new Array();
for (var j = 0; j < jstable.getRowIdentifierColumnNames().length; j++)
{
pkvals[j] = editr[x][jstable.getRowIdentifierColumnNames()[j]];
}
application.output('Table: '+tableSQLName +', PKs: '+ pkvals.join(',') +' ('+pkrec +')');
// Get a dataset with outstanding changes on a record
for( var i = 1 ; i <= ds.getMaxRowIndex() ; i++ )
{
application.output('Column: '+ ds.getValue(i,1) +', oldValue: '+ ds.getValue(i,2) +', newValue: '+ ds.getValue(i,3));
}
}
//in most cases you will want to set autoSave back on now
databaseManager.setAutoSave(true);
|
|
|
|
|
Table Body (tbody) |
---|
id | getFailedRecords |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getFailedRecords |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| JSRecord[] |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getFailedRecords |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns an array of records that fail after a save. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns JSRecord[] – Array of failed JSRecords |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var array = databaseManager.getFailedRecords()
for( var i = 0 ; i < array.length ; i++ )
{
var record = array[i];
application.output(record.exception);
if (record.exception.getErrorCode() == ServoyException.RECORD_VALIDATION_FAILED)
{
// exception thrown in pre-insert/update/delete event method
var thrown = record.exception.getValue()
application.output("Record validation failed: "+thrown)
}
// find out the table of the record (similar to getEditedRecords)
var jstable = databaseManager.getTable(record);
var tableSQLName = jstable.getSQLName();
application.output('Table:'+tableSQLName+' in server:'+jstable.getServerName()+' failed to save.')
}
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getFoundSet |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| JSFoundset |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getFoundSet |
Span |
---|
| (server_name/data_source, [table_name]) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns a foundset object for a specified datasource or server and tablename. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters server_name/data_source – The servername or datasource to get a JSFoundset for. [table_name] – The tablename of the first param was the servername. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns JSFoundset – A new JSFoundset for that datasource. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var fs = databaseManager.getFoundSet(controller.getDataSource())
var ridx = fs.newRecord()
var record = fs.getRecord(ridx)
record.emp_name = 'John'
databaseManager.saveData()
|
|
|
|
|
Table Body (tbody) |
---|
id | getFoundSetCount |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getFoundSetCount |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Number |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getFoundSetCount |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns the total number of records in a foundset. NOTE: This can be an expensive operation (time-wise) if your resultset is large. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {Object} foundset – The JSFoundset to get the count for. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Number – the foundset count |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//return the total number of records in a foundset.
databaseManager.getFoundSetCount(foundset);
|
|
|
|
|
Table Body (tbody) |
---|
id | getFoundSetDataProviderAsArray |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getFoundSetDataProviderAsArray |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Object[] |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getFoundSetDataProviderAsArray |
Span |
---|
| (foundset, dataprovider) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns a foundset dataprovider (normally a column) as JavaScript array. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {Object} foundset – The foundset {String} dataprovider – The dataprovider for the values of the array. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Object[] – An Array with the column values. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
// returns an array with all order_id values of the specified foundset.
var array = databaseManager.getFoundSetDataProviderAsArray(foundset,'order_id');
|
|
|
|
|
Table Body (tbody) |
---|
id | getFoundSetUpdater |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getFoundSetUpdater |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getFoundSetUpdater |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns a JSFoundsetUpdater object that can be used to update all or a specific number of rows in the specified foundset. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {Object} foundset – The foundset to update. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns JSFoundSetUpdater – The JSFoundsetUpdater for the specified JSFoundset. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//1) update entire foundset
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
fsUpdater.setColumn('customer_type',1)
fsUpdater.setColumn('my_flag',0)
fsUpdater.performUpdate()
//2) update part of foundset, for example the first 4 row (starts with selected row)
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
fsUpdater.setColumn('customer_type',new Array(1,2,3,4))
fsUpdater.setColumn('my_flag',new Array(1,0,1,0))
fsUpdater.performUpdate()
//3) safely loop through foundset (starts with selected row)
controller.setSelectedIndex(1)
var count = 0
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
while(fsUpdater.next())
{
fsUpdater.setColumn('my_flag',count++)
}
|
|
|
|
|
Table Body (tbody) |
---|
id | getNextSequence |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getNextSequence |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Object |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getNextSequence |
Span |
---|
| (dataSource|serverName, [tableName], columnName) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Gets the next sequence for a column which has a sequence defined in its column dataprovider properties. NOTE: For more infomation on configuring the sequence for a column, see the section Auto enter options for a column from the Dataproviders chapter in the Servoy Developer User's Guide. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters dataSource|serverName – The datasource that points to the table which has the column with the sequence, or the name of the server where the table can be found. If the name of the server is specified, then a second optional parameter specifying the name of the table must be used. If the datasource is specified, then the name of the table is not needed as the second argument. [tableName] – The name of the table that has the column with the sequence. Use this parameter only if you specified the name of the server as the first parameter. {String} columnName – The name of the column that has a sequence defined in its properties. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Object – The next sequence for the column, null if there was no sequence for that column or if there is no column with the given name. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var seqDataSource = forms.seq_table.controller.getDataSource();
var nextValue = databaseManager.getNextSequence(seqDataSource, 'seq_table_value');
application.output(nextValue);
nextValue = databaseManager.getNextSequence(databaseManager.getDataSourceServerName(seqDataSource), databaseManager.getDataSourceTableName(seqDataSource), 'seq_table_value')
application.output(nextValue);
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getSQL |
Span |
---|
| (foundset, includeFilters) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns the internal SQL which defines the specified (related)foundset. Optionally, the foundset and table filter params can be excluded in the sql (includeFilters=false). Make sure to set the applicable filters when the sql is used in a loadRecords() call. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {Object} foundset – The JSFoundset to get the sql for. {Boolean} includeFilters – optional, include the foundset and table filters, default true. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String – String representing the sql of the JSFoundset. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var sql = databaseManager.getSQL(foundset)
|
|
|
|
|
Table Body (tbody) |
---|
id | getSQLParameters |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getSQLParameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Object[] |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getSQLParameters |
Span |
---|
| (foundset, includeFilters) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns the internal SQL parameters, as an array, that are used to define the specified (related)foundset. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {Object} foundset – The JSFoundset to get the sql parameters for. {Boolean} includeFilters – optional, include the parameters for the filters, default true. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Object[] – An Array with the sql parameter values. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var sqlParameterArray = databaseManager.getSQLParameters(foundset)
|
|
|
|
|
Table Body (tbody) |
---|
id | getServerNames |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getServerNames |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String[] |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getServerNames |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns an array with all the server names used in the solution. NOTE: For more detail on named server connections, see the chapter on Database Connections, beginning with the Introduction to database connections in the Servoy Developer User's Guide. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String[] – An Array of servernames. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var array = databaseManager.getServerNames()
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| JSTable |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getTable |
Span |
---|
| (foundset/record/datasource/server_name, [table_name]) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns the JSTable object from which more info can be obtained (like columns). The parameter can be a JSFoundset,JSRecord,datasource string or server/tablename combination. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters foundset/record/datasource/server_name – The data where the JSTable can be get from. [table_name] – The tablename of the first param is a servername string. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns JSTable – the JSTable get from the input. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var jstable = databaseManager.getTable(controller.getDataSource());
//var jstable = databaseManager.getTable(foundset);
//var jstable = databaseManager.getTable(record);
//var jstable = databaseManager.getTable(datasource);
var tableSQLName = jstable.getSQLName();
var columnNamesArray = jstable.getColumnNames();
var firstColumnName = columnNamesArray[0];
var jscolumn = jstable.getColumn(firstColumnName);
var columnLength = jscolumn.getLength();
var columnType = jscolumn.getTypeAsString();
var columnSQLName = jscolumn.getSQLName();
var isPrimaryKey = jscolumn.isRowIdentifier();
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getTableCount |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Number |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getTableCount |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns the total number of records(rows) in a table. NOTE: This can be an expensive operation (time-wise) if your resultset is large |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {Object} dataSource – Data where a server table can be get from. Can be a foundset, a datasource name or a JSTable. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Number – the total table count. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//return the total number of rows in a table.
var count = databaseManager.getTableCount(foundset);
|
|
|
|
|
Table Body (tbody) |
---|
id | getTableFilterParams |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getTableFilterParams |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Object[][] |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getTableFilterParams |
Span |
---|
| (server_name, [filter_name]) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns a two dimensional array object containing the table filter information currently applied to the servers tables. The "columns" of a row from this array are: tablename,dataprovider,operator,value,tablefilername |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters server_name – The name of the database server connection. [filter_name] – The filter name for which to get the array. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Object[][] – Two dimensional array. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var params = databaseManager.getTableFilterParams(databaseManager.getDataSourceServerName(controller.getDataSource()))
for (var i = 0; params != null && i < params.length; i++)
{
application.output('Table filter on table ' + params[i][0]+ ': '+ params[i][1]+ ' '+params[i][2]+ ' '+params[i][3] +(params[i][4] == null ? ' [no name]' : ' ['+params[i][4]+']'))
}
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getTableNames |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String[] |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getTableNames |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns an array of all table names for a specified server. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {String} serverName – The server name to get the table names from. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String[] – An Array with the tables names of that server. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//return all the table names as array
var tableNamesArray =databaseManager.getTableNames('user_data');
var firstTableName = tableNamesArray[0];
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getViewNames |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String[] |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getViewNames |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns an array of all view names for a specified server. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {String} serverName – The server name to get the view names from. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String[] – An Array with the view names of that server. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//return all the view names as array
var viewNamesArray =databaseManager.getViewNames('user_data');
var firstViewName = viewNamesArray[0];
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| hasLocks |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns true if the current client has any or the specified lock(s) acquired. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters [lock_name] – The lock name to check. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if the current client has locks or the lock. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var hasLocks = databaseManager.hasLocks('mylock')
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
hasNewRecords |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| hasNewRecords |
Span |
---|
| (foundset/record, [foundset_index]) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns true if the argument (foundSet / record) has at least one row that was not yet saved in the database. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters foundset/record – The JSFoundset or JSRecord to test. [foundset_index] – The record index in the foundset to test (not specified means has the foundset any new records) |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if the JSFoundset has new records or JSRecord is a new record. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var fs = databaseManager.getFoundSet(databaseManager.getDataSourceServerName(controller.getDataSource()),'employees');
databaseManager.startTransaction();
var ridx = fs.newRecord();
var record = fs.getRecord(ridx);
record.emp_name = 'John';
if (databaseManager.hasNewRecords(fs)) {
application.output("new records");
} else {
application.output("no new records");
}
databaseManager.saveData();
databaseManager.commitTransaction();
|
|
|
|
|
Table Body (tbody) |
---|
id | hasRecordChanges |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
hasRecordChanges |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| hasRecordChanges |
Span |
---|
| (foundset/record, [foundset_index]) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns true if the specified foundset, on a specific index or in any of its records, or the specified record has changes. NOTE: The fields focus may be lost in user interface in order to determine the edits. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters foundset/record – The JSFoundset or JSRecord to test if it has changes. [foundset_index] – The record index in the foundset to test (not specified means has the foundset any changed records) |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if there are changes in the JSFoundset or JSRecord. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
if (databaseManager.hasRecordChanges(foundset,2))
{
//do save or something else
}
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
hasRecords |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| hasRecords |
Span |
---|
| (foundset/record, [qualifiedRelationString]) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns true if the (related)foundset exists and has records. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters foundset/record – A JSFoundset to test or a JSRecord for which to test a relation [qualifiedRelationString] – The relationname if the first param is a JSRecord. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if the foundset/relation has records. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
if (elements.customer_id.hasRecords(orders_to_orderitems))
{
//do work on relatedFoundSet
}
//if (elements.customer_id.hasRecords(foundset.getSelectedRecord(),'orders_to_orderitems.orderitems_to_products'))
//{
// //do work on deeper relatedFoundSet
//}
|
|
|
|
|
Table Body (tbody) |
---|
id | hasTransaction |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
hasTransaction |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| hasTransaction |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns true if there is an transaction active for this client. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if the client has a transaction. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var hasTransaction = databaseManager.hasTransaction()
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
mergeRecords |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| mergeRecords |
Span |
---|
| (source_record, combined_destination_record, [columnnamesarray_to_copy]) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Merge records from the same foundset, updates entire datamodel (via foreign type on columns) with destination record pk, deletes source record. Do use a transaction! returns true if successful. NOTE: For more information on foreign types, see Properties options: Details in the Dataproviders chapter of the Servoy Developer User's Guid |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters source_record – The source JSRecord to copy from. combined_destination_record – The target/destination JSRecord to copy into. [columnnamesarray_to_copy] – The column names Array that should be copied. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if the records could me merged. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
databaseManager.mergeRecords(foundset.getRecord(1),foundset.getRecord(2));
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
recalculate |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| void |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| recalculate |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Can be used to recalculate a specified record or all rows in the specified foundset. May be necessary when records are inserted in a program external to Servoy. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {Object} foundsetOrRecord – JSFoundset or JSRecord to recalculate. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns void |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
// recalculate one record from a foundset.
databaseManager.recalculate(foundset.getRecord(1));
// recalculate all records from the foundset.
// please use with care, this can be expensive!
//databaseManager.recalculate(foundset);
|
|
|
|
|
Table Body (tbody) |
---|
id | refreshRecordFromDatabase |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
refreshRecordFromDatabase |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| refreshRecordFromDatabase |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Flushes the client data cache and requeries the data for a record (based on the record index) in a foundset or all records in the foundset. Used where a program external to Servoy has modified the database record. Record index of -1 will refresh all records in the foundset and 0 the selected record. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {Object} foundset – The JSFoundset to refresh {Number} index – The index of the JSRecord that must be refreshed (or -1 for all). |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if the refresh was done. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//refresh the second record from the foundset.
databaseManager.refreshRecordFromDatabase(foundset,2)
//flushes all records in the related foundset (-1 is or can be an expensive operation)
databaseManager.refreshRecordFromDatabase(order_to_orderdetails,-1);
|
|
|
|
|
Table Body (tbody) |
---|
id | releaseAllLocks |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
releaseAllLocks |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| releaseAllLocks |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Release all current locks the client has (optionally limited to named locks). return true if the locks are released. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters [lock_name] – The lock name to release. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if all locks or the lock is released. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
databaseManager.releaseAllLocks('mylock')
|
|
|
|
|
Table Body (tbody) |
---|
id | removeTableFilterParam |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
removeTableFilterParam |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| removeTableFilterParam |
Span |
---|
| (serverName, filterName) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Removes a previously defined table filter. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {String} serverName – The name of the database server connection. {String} filterName – The name of the filter that should be removed. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if the filter could be removed. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var success = databaseManager.removeTableFilterParam('admin', 'higNumberedMessagesRule')
|
|
|
|
|
Table Body (tbody) |
---|
id | rollbackEditedRecords |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
rollbackEditedRecords |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| void |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| rollbackEditedRecords |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Rolls back in memory edited records that are outstanding (not saved). Best used in combination with the function databaseManager.setAutoSave() This does not include deletes, they do not honor the autosafe false flag so they cant be rollbacked by this call. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns void |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//Set autosave, if false then no saves will happen by the ui (not including deletes!). Until you call saveData or setAutoSave(true)
//Rollbacks in mem the records that were edited and not yet saved. Best used in combination with autosave false.
databaseManager.setAutoSave(false)
//Now let users input data
//On save or cancel, when data has been entered:
if (cancel) databaseManager.rollbackEditedRecords()
databaseManager.setAutoSave(true)
|
|
|
|
|
Table Body (tbody) |
---|
id | rollbackTransaction |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
rollbackTransaction |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| void |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| rollbackTransaction |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Rollback a transaction started by databaseManager.startTransaction(). Will also rollback deletes that are done between start and a rollback call that are not handled by autosave false and rollbackEditedRecords() |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns void |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
// starts a database transaction
databaseManager.startTransaction()
//Now let users input data
//when data has been entered do a commit or rollback if the data entry is canceld or the the commit did fail.
if (cancel || !databaseManager.commitTransaction())
{
databaseManager.rollbackTransaction();
}
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| saveData |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Saves all outstanding (unsaved) data and exits the current record. Optionally, by specifying a record, can save a single record instead of all the data. NOTE: The fields focus may be lost in user interface in order to determine the edits. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters [record] – The JSRecord to save. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if the save was done without an error. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
databaseManager.saveData();
//databaseManager.saveData(foundset.getRecord(1));//save specific record
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
setAutoSave |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| setAutoSave |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Set autosave, if false then no saves will happen by the ui (not including deletes!). Until you call databaseManager.saveData() or setAutoSave(true) If you also want to be able to rollback deletes then you have to use databaseManager.startTransaction(). Because even if autosave is false deletes of records will be done. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {Boolean} autoSave – Boolean to enable or disable autosave. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – false if the current edited record could not be saved. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//Rollbacks in mem the records that were edited and not yet saved. Best used in combination with autosave false.
databaseManager.setAutoSave(false)
//Now let users input data
//On save or cancel, when data has been entered:
if (cancel) databaseManager.rollbackEditedRecords()
databaseManager.setAutoSave(true)
|
|
|
|
|
Table Body (tbody) |
---|
id | setCreateEmptyFormFoundsets |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| void |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| setCreateEmptyFormFoundsets |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Turnoff the initial form foundset record loading, set this in the solution open method. Simular to calling foundset.clear() in the form's onload event. NOTE: When the foundset record loading is turned off, controller.find or controller.loadAllRecords must be called to display the records |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns void |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//this has to be called in the solution open method
databaseManager.setCreateEmptyFormFoundsets()
|
|
|
|
|
Table Body (tbody) |
---|
id | startTransaction |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
startTransaction |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| void |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| startTransaction |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Start a database transaction. If you want to avoid round trips to the server or avoid the posibility of blocking other clients because of your pending changes, you can use databaseManager.setAutoSave(false/true) and databaseManager.rollbackEditedRecords(). startTransaction, commit/rollbackTransacton() does support rollbacking of record deletes which autoSave = false doesnt support. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns void |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
// starts a database transaction
databaseManager.startTransaction()
//Now let users input data
//when data has been entered do a commit or rollback if the data entry is canceld or the the commit did fail.
if (cancel || !databaseManager.commitTransaction())
{
databaseManager.rollbackTransaction();
}
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
switchServer |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| switchServer |
Span |
---|
| (sourceName, destinationName) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Switches a named server to another named server with the same datamodel (Recommended to be used in an onLoad method for a solution). return true if successfull. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters {String} sourceName – The name of the source database server connection {String} destinationName – The name of the destination database server connection. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – true if the switch could be done. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//dynamically changes a server for the entire solution, destination database server must contain the same tables/columns!
//will fail if there is a lock, transaction , if repository_server is used or if destination server is invalid
//in the solution keep using the sourceName every where to reference the server!
var success = databaseManager.switchServer('crm', 'crm1')
|
|
|
|
|
|