Building applications around M-Files

Several procedures, functions and special columns in the metadata tables are specifically designed for using with building applications.

Procedures applied in building applications in the use cases include:

Procedure/Function	Use
fnObjectHyperlink	Create hyperlink to object for external application
spMFCreatePublicSharedLink	Create public link on demand
spMFContextMenuActionItem	Create and update records in Context Menu
spMFContextMenuHeadingItem
spMFDeleteObjectList	Remove objects from M-Files
spMFCreateValuelistLookupView	Create valuelist and workflow state lookups
spMFCreateAllLookups	Rapidly create all lookups
spMFCreateWorkflowStateLookupView
spMFCreateTable	Create class tables
spMFCreateAllMFTables	Rapidly creation of class tables
spMFDropAllClassTables	Rapidly delete all class tables
spMFSearchForObject	Rapid search for objects
spMFSearchForObjectsByPropertyValue	Searching for objects within specific properties
spMFSynchronizeMetadata	Synchronize all metadata
spMFSynchronizeSpecificMetadata	Synchronize only specific metadata
spMFDropAndUpdateMetadata
spMFAliasesUpsert	Updating aliases
spMFExportFiles	Export files from M-Files
spMFGetHistory	Get Object history
spMFGetMFilesLog	Get MfilesEventLog
spMFupdateTable	Update M-Files and SQL (Note use of filters)
spMFUpdateAllIncludedInAppTables	Rapid update of all tables included in app
spMFUpdateMfilesToSQL	Batch updates based on objid
spMFUpdateTableWithLastModifiedDate	Update only records since last update
spMFClassTableStats	Monitor status of class tables
spMFLogTableStats	Logging and messaging of process flow
spMFLogError_Email
spMFProcessBatch_Upsert
spMFProcessBatchDetail_Insert
spMFResultMessageforUI
spMFUpdateHistoryShow

Special columns used in the above applications are:

Table	Column	Use
MFValuelistitems	AppRef	Unique reference to valuelistitem for rapid validation and cross referencing rule conditions
MFClass	IncludeInApp	Set transaction level update; bulk update of all tables
	FileExportFolder	Set the root for export files for the class
	SynchPrecendence	Set Synch precedence for the class
Class Tables	MXuser_ID	Membership update identification
	Update_ID	Get updated items after process completed
	FileCount	Determine number of files in object
	Guid	Create hyperlink to object