AddTablefilterparam?

Classic Servoy
1

Can someone provide an example of using

Databasemanager.AddTablefilterparam

The first argument in the example is “Databasename”? What database name? The DB Schema name? THe Servoy Solution name? The DB Connection Name? I’m not quite sure what goes here. I’ve been using my TNS name for Oracle, but that is not working?

Thanks,
Lee Snover

2

Which version of Servoy are you on, because my tooltip for that fucntions says as first param the servername, which is the name of the DBlink that you configured in Servoy.

Paul

3

See the tooltip. There it says

boolean addTableFilterParam(String servername, String tablename, String dataprovider, String operator, Object value)

So if you want to filter in a table “addresses” in server “myServer” (the name of the server connection), where “city” equals “New York” you write

addTableFilterParam('myServer', 'addresses', 'city', '=', 'New York');
4

pbakker:
Which version of Servoy are you on, because my tooltip for that fucntions says as first param the servername, which is the name of the DBlink that you configured in Servoy.

Paul

Sorry meant Servername, but I’m not sure what that should be. My repository name? Solution_Name?

5

The name of the DB Server you setup in Servoy under Preferences/DB Servers, for example CRM, Example_Data, Repository etc, etc

Paul