i try to omit records from a foundset that match a certain word. This ia a onSearch method.
- Code: Select all
var name = arguments[2].getSource().getName()
var form = controller.getName()
var frm = solutionModel.getForm(form)
var field = frm.getField(name)
var dataProvider = field.dataProviderID
var data = forms[form].controller.getDataProviderValue(dataProvider)
var searchData = utils.stringReplace('#%' + data + '%',"\n","")
var jstable = databaseManager.getTable(controller.getDataSource());
var tableSQLName = jstable.getSQLName();
var columnNamesArray = jstable.getColumnNames();
var firstColumnName = columnNamesArray[0];
var jscolumn = jstable.getColumn(firstColumnName);
var columnSQLName = jscolumn.getSQLName();
var isPrimaryKey = jscolumn.isRowIdentifier();
controller.loadAllRecords()
var query = "SELECT " + firstColumnName + " FROM " + tableSQLName + " WHERE " + dataProvider + " NOT LIKE '" + searchData +"'"
foundset.loadRecords(query)
But it doesn't work. It finds that record instead of omit it. I also tried wit the != operator with the same result.