Getting ready for reporting¶
Getting ready for reporting
-- identify all the class tables to be included in reports
SELECT * FROM mfclass
-- set Include in App for all required tables
UPDATE MFClass
SET IncludeInApp = 1
WHERE Name IN ('Contact Person','Customer','Customer Project','Sales Invoice')
-- validate
Select TableName from MFClass where IncludeInApp = 1
-- auto create all the class tables
EXEC spMFCreateAllMFTables
-- pull from MF for all class tables ( WARNING - THIS MAY BE LONG RUNNING IF THERE ARE MANY RECORDS IN THE TABLE)
exec spMFUpdateAllncludedInAppTables @UpdateMethod = 1
-- check table stats
exec spMFClassTableStats
GO