JOIN 1:1 |
  
|
JOIN 1:1 |
|
Configure a JOIN 1:1 element to join a table configured in WebOffice 10.5 SP2 with a search result view.
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.5 SP2 project configuration
•target table: a table configured in WebOffice 10.5 SP2 whose attributes should be joined to the source table
The join relation is defined by specifying a key field for each of the two tables used for linking the two tables (key of source table, key of target 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
Property |
Description |
Keep all records |
Use outer join (Yes) or inner join (No). Note: Consider the difference between outer and inner joins when having two tables A and B: - Outer join: Will give you all values of table A, even if there is no value in table B. Therefore, all records will be kept. - 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 target table configuration
Property |
Description |
Key of source table |
Key field of the source layer/table to be used. Note: The key field must be configured as result field in the search result view where the JOIN element is configured.  Result field of source table/layer
|
Key of target table |
Key field of the target table to be used. Note: The Key field must be configured as result field in the table configuration.  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.5 SP2 clients.
Note: See chapter Result Field List for details about the configuration of result fields.
Note: See chapter DB Connections for details about the configuration of database connections.
Note: See chapter Tables for details about the configuration of tables.
Note: See chapter Related Results for the appearance of joins and relates in the WebOffice html client.
Note: See also chapter Joins and Relates for information about the concept of WebOffice joins/relates.