DWH support for scripted autocomplete fields (#664680)

Data fields of the type Autocomplete can now be transferred to the data warehouse to be used in reports.

The following information is transferred if Transfer to DWH is set to True for the field:

• Internal value: The internal value is stored in a column named after the field. For autocomplete fields of the type Case, Contact, Resource and User, which store a reference to the entity in the internal value, the transfer key of the entity from the DWH is used, so that it is possible to join data from the entity in reports. The history of internal values is saved to the columns old_value_uid and new_value_uid.
• Display value: Stored in a column named after the field with the suffix _displayValue. The history of display values is saved to the columns old_value and new_value.

Update behavior

If an autocomplete field already had the setting Transfer to DWH applied, the setting is automatically removed on update. If a field group has this setting, all autocomplete fields which belong to the group receive the setting Transfer to DWH with the value False. Therefore, you need to set Transfer to DWH to True manually to transfer autocomplete fields to the DWH.