Tables |
  
|
Tables |
|
Use the Tables element for configuring read access to database tables.
Access to database tables can be used for
•Searching on database tables (Predefined queries, Query builder queries),
•Joining and / or relating Search results of Layer or Table searches with database tables,
•Providing Lookup functionality (i.e. displaying e.g. string description values from a Lookup table in WebOffice 10 R3 client instead of numeric ID values from the Layer / Table itself).
Table configuration
Property |
Description |
Name |
Full Name of Table. If using RDBMS, schema and table name have to be included (i.e. SCHEMA.TABLENAME). Some RDBMS (SQL Server) need additional information on the DB-Owner (OWNER.SCHEMA.TABLENAME). Note that Oracle DB (upper case) as well as PostGIS (lower case) need case sensitive schema and table names. |
Database connection |
Database connection necessary for accessing the table. See chapter Database Connection for details. |
Alias name |
Table name displayed in WebOffice client. |
Search possible? |
Specifies if it is possible to use Predefined queries / Query builder query functionality to search on the Table. If the Table is configured for search (Yes) then •the List of search fields as well as •one or more Predefined queries must be configured. One or more Search results may be configured for each query. Note: If the Table is used for Lookup only, then set 'No’. |
Table configuration
See chapter Query for details on Query configuration of Tables.