Property and column usage

The procedure spMFClassTableColumns works through all the properties and related columns for class tables and provides a report on the usage of properties in the connector. This report is particularly powerful in complex vaults with multiple integration points.

The result of the procedure is saved to a temporary table. This table can be used in subsequent processes to detect potential anomalies and trigger corrective action.

EXEC [dbo].[spMFClassTableColumns]
SELECT * FROM ##spMFClassTableColumns

The rich set of data includes:

  • ColumnType showing if the property is in use; defined on the metadata card; adhoc property; or a M-Files system property

  • Both SQL data types and M-Files data types are shown

  • Columns at the end of the table show error statuses for Datatype errors, Missing columns, Missing Tables, or if a table is not longer in use.

image6

spMFDropAndUpdateMetadata detects inconsistencies with column usage and automatically updates the metadata.

spMFUpdateTable validates columns and automatically executes updating of the metadata if the metadata has changed since the last update. Note that this check could increase the run time for spMFUpdateTable significantly when executed just after a metadata change in the vault.