Archibus SaaS / System / Archibus Administrator - Application Configuration
System / Archibus Administrator - Application Configuration

Merge Primary Key

The Merge Primary Key command enables you to migrate all child records that reside beneath one record (for example, Building “HQ”) to another record (for example, Building “HCN”). The Merge command performs essentially the same action as the cascading update feature, except that the new value can already exist. A cascading update will fail if the new value exists.

Use Cases

The Merge Primary Key command is useful when updating your data to reflect reorganizations, and when completing cascading updates that have failed:

• Merging. Reorganizations can merge departments; renovations can merge rooms. Changes in corporate standards and integration of data from different sites can merge standards categories.
• Completing Cascading Update. If you have an incomplete cascading update, with child records only partially moved to a new parent, the Merge Primary Key action will complete the update, regardless of the state of the original update when it stopped.

How to Merge Primary Keys

To merge primary key values:

1. Select the Archibus Administrator - Application Administration / Merge Primary Key task.
2. Enter the table to update.
3. In the From field, enter the primary key value for the record which will have all its children reassigned, and then be deleted if the merge executes successfully.
4. In the To field, enter the primary key value for the record which will become the new owner of the reassigned child records. If the selected table has a multipart key, the values for all of the multipart keys must be entered.
5. Click OK.

   The Update Cascade workflow rule runs and makes the specified changes.

See Also

How to Edit Primary Keys that Link to Other Tables