The database fields in the document table and the linked data tables, from which values are to be extracted, are specified in the fieldtoread XML element. For each fieldtoread XML element, a line of the form
<attribute type="Type">Value</attribute>
is written to the XML output file.
Type is made up of the table name, the data field name, and an optional text field name.
Value is the value extracted from the corresponding data field. All values are written in text form.
Optionally, instead of the direct data field value, the value of the referenced table (textref XML element) can be extracted. The optional langfieldname specification extracts the language-specific text of the data field.
Supplementary information is extracted from the data tables using primary key relations.
XML element |
XML attribute |
Description |
---|---|---|
fieldtoread |
name |
Name of the table column containing the data field to be extracted |
textref |
tablename |
Table name of the referenced data table |
|
reffieldname |
Name of foreign key |
|
textfieldname |
Name of the table column containing the data field to be extracted |
|
langfieldname |
Name of the table column containing the language-specific data field to be extracted |
fkpart |
readfrom |
Direction of the substring forming the foreign key |
|
startposition |
Position from which the substring is formed |
|
length |
Length of substring |
Before data is actually extracted, a check is run as to whether the configured tables and data fields exist and whether the specified system user has appropriate access authorization.
Example
The extracted field values are written to the XML output file as attributes of a system event.
Unlocalized table fields:
...
<attribute type="VBAP-WERKS">SB</attribute>
...
Localized table fields:
...
<attribute type="VBAP-WERKS-NAME">Saarbrücken</attribute>
...