With the element JOIN - 1:1 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 join element.

For a join 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 joined to the source table

 

The JOIN 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). In this process, one feature of the target table is assigned to each feature of the source table.

 

In the sample below, the cadastral municipality number (KGNR & KG_NR) fields of the involved table and layer are used as key fields.

 

JOIN 1:1 configuration

JOIN 1:1 configuration

 

Properties

Description

Keep all records

Specifies whether all records are retained in the result of the join (Yes, outer join) or not (No, inner join).

icon_comment

Consider the difference between outer and inner joins when having two tables A and B:

Outer join: All data of table A are displayed, although there is no data in table B. Consequently, all records are retained.

Inner join: Only values of table A with a matching value in table B will be kept. Some records may be dropped.

JOIN 1:1 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 joined fields simply get added to the search result in the WebOffice 10.9 SP1 clients.

 

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.