Tables and Views for Data Logging

The data_log_16 and data _log_48 tables have been removed from the database. All logged data values are now stored in the data_log table.

For backward compatibility, use the data_log_16 and data_log_48 views.

The MES Client Data Logger module's Create View function can be used to create a data log group view. The view is named vw_data_log_groupdesc, where groupdesc is the description of the data log group, with any spaces in the description string removed.

The view returns records from the data_log table with column names that match the names of the data log values within the group. The columns are cast to the data type defined for the data log values. Any additional columns are returned as valuen as a string.

If the casting fails on a valuen column, then that column value is returned with a null value for that row.