How to export records from multiple tables into one XML file, or add them to an update set [SwissNow]

2. Open options

Right click on SwissNow icon and select Optons.

In this example, we will be exporting data from sys_user table and all corresponding sys_user_has_role records.

Provide configuration package name (to describe the content being exported), e.g. User with roles
Provide main table exact name. In out case, the main table is sys_user
Define parent-child relationships of your configuration records
* Enter parent table name, e.g. sys_user
- Enter child table name, e.g. sys_user_has_role
- Enter a relationship qualification, e.g. user=${sys_id} (The qualification is applied to the child table - sys_user_has_role. In the qualification you should use fields from the parent table - sys_user - to define relationship between records. Use $[field} syntax to refer to parent record fields. In this example, "user" is a field from child table and "${sys_id}" will be replaced with the sys_id of a record from parent table - sys_user).
- Click "Add". (You can add as many parent-child relationships as you want. You can also add self-relationship, e.g. cmn_location --> cmn_location)
- Click "Save"

You can also open a list of records - just remember to apply a filter to the list of records.

To download all configuration records in single XML file, click Generate file
To add all configuration records to the current update set, click Add all to UpdateSet (note that sys_user table exceptionally cannot be added to an update set due to security constraints)

Labels: