Automerge
Description
Automerge creates the table _CEL_MERGED_ACTIVITIES by merging all available and merge-able event logs into the default event log.
Automerge uses MERGE_EVENTLOG functionality to merge all merge able tables in a tree structured manner.
The default eventlog is the target eventlog, that gets enhanced by the activities of all connected eventlogs. This means, that cases that exist in the case table of the target eventlog will get more activities from other eventlogs that have a join relationship to this case. If a case does not exist in the case table of the target eventlog, it will not show up in _CEL_MERGED_ACTIVITIES. This means, even if an activity has a join partner in another activity table but those have no connection to the default activity table, these activities will not show in the table _CEL_MERGED_ACTIVITIES.
If activity tables have the same column name but different types, separate columns are added to the table _CEL_MERGED_ACTIVITIES named by column name concatenated with the column type.
If automerge gets enabled (or disabled), a full data load is required for the change to take effect.
If the case table of an activity table is connected to the rest of the data model (where the default activity table is configured) via the activity table, the activity table is ignored.
Examples
[1] All columns from the three activity tables | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
[2] The column ADDITION5 appears in table Table1_Activity and Table3_Activity with type | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|