Navigation:  Introduction to WebOffice html Client > System Integration > Join/Relate

QueryCenter Standard database joins get displayed in the Search result by simply adding the joined fields as additional columns to the Search result.

QueryCenter Standard database relates get displayed when clicking on the Display related data button on the left hand side of each of the result rows.

 

 

The Related data window contains tools to select all rows and to export selected rows as comma separated values file (CSV). CSV files can be opened e.g. with MS Excel.

 

 

Basically WebOffice 10 R3 supports 'WebOffice-Relates' as well as 'ArcMap-Relates'. More details on 'WebOffice-Relates' please find in chapter Relate (1:n) Relation with other Database Table. An 'ArcMap-Relate' uses those relates, that are defined on a layer in ArcMap. WebOffice 10 R3 supports ArcMap-Relates

•between a layer and a table and

•between two layers.

 

Note: If a relate is defined between two layers, both layers have to be in the same data frame. All other configurations are not supported by WebOffice 10 R3.

 

'ArcMap-Relates' will automatically be transferred to WebOffice 10 R3. If more than one relates are defined on one layer, only the first one will be transferred to WebOffice 10 R3. The column width of the 'ArcMap-Relate'-result is by default 25 and cannot be extended. It is possible to define the order and the visibility of the fields of a relate result in the table properties or layer properties in the tab 'Fields' (ArcMap).

 

 

Note: If more than one layers are defined on a layer, WebOffice 10 R3 only supports the first relate.

 

Relates will also be used for 'Free labeling', more details please find in chapter Free Labeling.