All database tables used for tabular searches and/or lookup support (secondary tables) are stored here. Such tables of a relational database are addressed directly using a corresponding JDBC connection.

 

icon_cross-reference

A configured and valid database connection is required to configure a list of database tables. For more details on configuring a valid database connection, refer to the chapter Database connections.

 

Table (JDBC) configuration

Table (JDBC) configuration

 

Property

Description

Display Name (GUI)

Alias table name shown in the WebOffice 10.9 R4 clients.

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).

icon_comment

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.

icon_cross-reference

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.

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.

icon_comment

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).

Currently, it is not possible to restrict a table base search to the current spatial extent even if this parameter is set to true.

Show null values?

Specifies whether to show null values (true) or not (false) in the result display.

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.

icon_cross-reference

See chapter Layer Queries for details.

 

Table query configuration

Table query configuration

 

icon_comment

The full text search on Table (JDBC) is currently not yet supported.

 

Search field list and search field

Search field list and search field

 

List of predefined queries

List of predefined queries

 

icon_comment

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

List of search result views

 

icon_cross-reference

If Esri Archiving is activated for the configured table, you should configure the additional element Geodatabase Archiving. Find more details in chapter Geodatabase Archiving.