Views
Overview
A table view, commonly known as a "view," is a virtual table created by querying existing database tables. It doesn't store data but shows a real-time snapshot of chosen data from other tables.
Get Started
Once the database server connection has been set up, developers now have the possibility to access and manage database tables and views.
Read-Only Views cannot be defined in Servoy Developer, this can be done by using the database admin tool of the developer's choice.
Connecting to a View
If a view is made with database tools, you can find it in Servoy Developer within the Views
folder of the relevant database server.
Advanced Feature Only work with Views if you already use them.
Open a View
Servoy applications can access the database views that are already created.
To open an existing view, expand the Database Servers node in the Solution Explorer, then open the needed database and select the "Views" folder. The list of views will be displayed and there are 3 ways of opening a view:
select the View, then click on the
edit table/view
button in toolbar of the list viewright-click the View and select Edit table/view
double click the View name

Edit a View
Here you can manage:
View columns cannot be added nor deleted in Servoy Developer.
Updateable Views
Cached data
Last updated
Was this helpful?