Is there a way to force Servoy developer to ignore specific tables within a database? We use Servoy for a couple specific purposes and the database used by Servoy is also used by our other applications. A handful of tables don’t have unique keys defined due to the way the data is built and used. This generates build errors in the developer but because we don’t use these tables in Servoy I am not concerned about them and don’t need to resolve them. I just don’t want the build errors.
Hi Louis,
Yes, you can open the table in Developer then go to the Properties tab (at the bottom of the Table Editor) and check the option “Hidden in developer”.
The table will be moved to the end of the list and greyed out in the Solution Explorer. It should not give you any build problems.
This is Claude’s answer.
A few options in Servoy:
- Admin Console - Database Servers > select your server > there’s a “Table Filter” or catalog/schema
filter where you can exclude table name patterns - Servoy Developer - In Solution Explorer, expand the database server node, right-click a table and
look for options to hide/exclude it. Tables can be marked as metadata or hidden. - Server config - In the server connection settings you can restrict which catalog/schema Servoy
loads, which effectively hides tables in other schemas. - Move tables to a different schema - if it’s SQL Server, put tables you want hidden in a non-default
schema that Servoy isn’t configured to see.
Which scenario are you dealing with - too many tables cluttering the Developer view, or wanting to
prevent Servoy from accessing certain tables entirely?
The “Hide in developer” option appears to have done the trick. Thanks!