Add additional field from table with one-to-one relationship (CMS011)
This procedure defines fields from tables that have a one-to-one relationship against another table. If the information needed in the XML output is not included in any of the standard tables, but is included in a single related table record, you must define a related table, and select the fields that should be included. A related table is defined per printer file and XML section. Adding related tables has a small impact on output function performance.
After the field is defined, it can be selected as an element in (CMS009):
A quick entry for defining a related table by clicking 'Create New' on (CMS011/B) is also available. Click the button, and then specify the related table name and click OK.
If the read option between the related and master table can be determined automatically, the N panel displayed.
If the read options cannot be determined automatically, the E panel is displayed.
- Start (CMS006), select XML structure and use option 11='XML Structure. Open Section' to start (CMS007).
- Select structure and use option 11='XML Structure. Open Section Elements' in (CMS007) to start (CMS009).
- Click 'Related tables' to start 'Related Tables. Connect' (CMS011).
- Specify the table and use option 1='Create'.
- On the E panel, specify the sequence number which indicates the read sequence used for the related table.
- On the F panel, specify the sorting option used to read the related table. Specify the read option for every key field in the related table, based on the sorting option selected.
- On the G panel, specify the additional condition when reading the related table. Specify the filter group expression which indicates the logical operators to be used. Specify the group which indicates where the filter will be added, and select the source of data which indicates where the value is retrieved.
- On the N panel, specify field selection 1-'Specific fields'.
- Click 'Select field' and select the required field from the table.
- Repeat step 9 if additional fields are required.