With the element RELATE 1: n it is possible to display in the search result the data of a table related to the layer.

If you, e.g. want to display attributes of a specific city district which are not available in the layer itself then it is possible to provide access to additional district specific attributes/fields by configuring a relate element.

 

For a relate it is necessary to specify a source table and a target table:

source table: can be a layer or table that is configured in your WebOffice 10.9 SP1 project configuration

target table: a table configured in WebOffice 10.9 SP1 whose attributes should be related to the source table

 

icon_comment

Only JDBC tables are supported as target tables for relates, not tables from ArcGIS Services.

 

The relationship is defined by specifying a key field in both tables, which is used to link them (reference to result field, reference to table field). Several features of the target table are assigned to one feature of the source table. In the sample below, the cadastral municipality number (KGNR) fields of the involved table and layer are used as key fields.

 

icon_comment

WebOffice 10.9 SP1 does support nested relates, but it does not support the configuration of relates with circle reference.

Therefore, it is possible to configure:

Layer X > Table 1 > Table 2

 

Following configuration is not possible:

Layer Y > Table 1 > Table 1

Layer Z > Table 2 > Table 3 > Table 2

 

RELATE 1:n configuration

RELATE 1:n configuration

 

Property

Description

Organisation

Specify a name for the relate.

RELATE 1:n properties

 

Key of source table configuration

Key of source table configuration

 

Key of target table configuration

Key of target table configuration

 

Property

Description

Key of source table

Key field of the source layer/table to be used.

icon_comment

The key field must be configured as result field in the superior search result.

Result field of source table/layer

Result field of source table/layer

 

Key of target table

Key field of the target table to be used.

icon_comment

The key field must be configured as result field in the table configuration.

Result field of target table

Result field of target table

 

Key of source table/Key of target table properties

 

The related table will be accessible via a button in the search result of the WebOffice 10.9 SP1 client. It is possible to configure multi-level object relations for navigating through a data model (e.g. from a building layer to a facade table (1:N) and from the facade table to a window table (1:N)).

In this case

the first relate (between the layer and the 1.table) has to be configured in the search result view of the layer query

the second relate (between the 1.table and the 2.table) has to be configured in the search result view of the 1.table query

 

icon_comment

To open the view Related Features in the batch menu, this can be suppressed under the Common Settings of the WebOffice 10.9 SP1 project.

 

Configuration of the first relate

Configuration of the first relate

 

Configuration of the second relate

Configuration of the second relate

 

icon_cross-reference

See chapter Result Field List for details about the configuration of result fields.

See chapter DB Connections for details about the configuration of database connections.

See chapter Tables for details about the configuration of tables.

See chapter Related Results for the appearance of joins and relates in the WebOffice html client.

See also chapter Joins and Relates for information about the concept of WebOffice joins/relates.