Overview

You have enabled Enabled the History feature for one or more Info Areas, are now wondering if the full data set can be exported via SQL query from the database back-end, and whether it can be exported to a different DB via the Export module.

Information

Information for the History (H0) Info Area is stored in the Binary Large Object (Blob) format; therefore, they will not be readable through a regular SQL query. In order to export this information, it will be necessary to generate a Report in the XML Format.

You can use the following virtual fields to output history records in XML reports or to export data in the history: ID, Stat.No., Date, Time, Rep ID, Rep, Windows User Name, Windows computer name, Version, Module, Field Number, Field Name, Old Value, New Value, Time Zone.

Please refer to the manual to learn how to Define a Report Format and Generate the Corresponding Report.