Tables |
  
|
Tables |
|
The entire database tables used for querying and/or for providing lookup functionality are stored here. A list of table elements can be configured.
Table configuration
Property |
Description |
Name |
Full name of table. If using relational database system (RDBMS), schema and table name of the database, the table definition has to be used (i.e. SCHEMA.TABLENAME). Some RDBMS (SQL Server) require additional information on the DB owner (OWNER.SCHEMA.TABLENAME). Note: Oracle DB requires case sensitive schema and table names. |
Reference to Database connection |
Database connection to be used for actually connecting to the database table using JDBC. Note: All connections configured under Database connections will be available in den drop down list. See chapter Database Connection for more information about configuration of database connections. |
Display Name (GUI) |
Alias table name shown in the WebOffice 10.2 SP3 clients. |
Show null values? |
Specifies whether to show null values (Yes) or not (No) in the result display. |
Use joined Layer? |
Specifies whether the join element of a layer search result configuration is used for displaying a layer search result (attribute data as well as objects in the map) when searching on table fields. Note: To use this functionality, a join from the layer (Layer queries) to this table is the precondition. This way you can search on the tables data and get the attributes and spatial information of the joined layer (layer the join is based on). Note: Currently, it is not possible to restrict a table base search to the current spatial extent even if this parameter is set to "Yes". |
Table properties
In order to configure all relevant aspects for table search and result display a set of configuration elements should be taken into consideration:
| • | Query: Specify generic query (Query Builder) behavior, |
| • | Search Field List: Specify all available search fields. Search fields can be used in either |
| • | Query Builder or |
| • | Predefined query |
| • | List of Predefined Queries: Multiple predefined queries can be configured. This makes the search & find process much easier for the user, |
| • | List of Search Result Views: Multiple search results can be configured to provide different "views" on the data. |
See chapter Layer Queries for details.
Table query configuration
Search field list and search field
List of predefined queries
Note: The parameters "Permit spatial attributive search function?" and "Spatial attributive Search activated per default?" currently only work with spatial feature classes, i.e. the above mentioned parameters have no function for attributive table queries.
List of search result views