addTableFilterParam

Hi,

I have problems with the “addTableFilterParam”. As I understand, this filter works similary as the “addFoundsetFilterParam”. It should be possible, to set more than one filter (AND) on the same table?

If I set a second filter, see example below, the first filter becomes ignored. Is it possible, that we can only set one filter to a table or am I doing something wrongli?

Example:
//return all table names from meta-data server
vTableNamesArray = databaseManager.getTableNames(globals.mgtSysGlobals_currentMbfServer1Name);

//set filter on tables from meta-data server
var vSuccess;
for ( var i = 0 ; i < vTableNamesArray.length ; i++ )
{
vSuccess = databaseManager.addTableFilterParam(globals.mgtSysGlobals_currentMbfServer1Name, vTableNamesArray*, ‘datadomain_id’, ‘=’, 0);*
vSuccess = databaseManager.addTableFilterParam(globals.mgtSysGlobals_currentMbfServer1Name, vTableNamesArray*, ‘rec_status’, ‘<=’, 4);
_
}*_
Hans-Peter

I am bumping into this right now!

Is it possible to use multiple statements??

ah, found it myself: http://forum.servoy.com/viewtopic.php?t … ilterparam