RELATE 1:n
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 R4 project configuration
•target table: a table configured in WebOffice 10.9 R4 whose attributes should be related to the source table
|
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.
|
WebOffice 10.9 R4 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
Property |
Description |
|---|---|
Organisation |
Specify a name for the relate. |
RELATE 1:n properties
Key of source table configuration
Key of target table configuration
Property |
Description |
||
|---|---|---|---|
Key of source table |
Key field of the source layer/table to be used.
 Result field of source table/layer
|
||
Key of target table |
Key field of the target table to be used.
 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 R4 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
|
To open the view Related Features in the batch menu, this can be suppressed under the Common Settings of the WebOffice 10.9 R4 project. |
Configuration of the first relate
Configuration of the second relate
|
•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. |
