Example scripts to get started
Examples scripts for the most common procedures and functions are included. The scripts can be loaded from this guide or can be found in the installation folder. The scripts are prepared using a standard M-Files Sample vault and will include illustrations using objects from this vault.
The scripts are located at: InstallationFolder\Laminin Solutions\MFSQL Connector Release 4\DatabaseName\Example Scripts
We are incorporating these examples into this documentation and guide as examples and illustrations on the use of the procedures. Over time the examples in the folder will reduce as we incorporate them into the body of the guide. You will find them in the with more practical tips. Just search on the procedure or topic in the guide.
Open the scripts in SSMS. Follow the guidelines in the scripts to select the instructions in blocks rather than executing the entire script.
Use the scripts in conjunction with this guide.
Getting started
Working with deletion
All scripts
Below is an auto-generated list of all script pages in this folder. As more SQL files are converted to reStructuredText, they will appear here automatically.
- Getting Started
- Updating settings
- Quick startup for multiple class tables
- Initialize the application
- Metadata Structure Changes
- Metadata Update Development: Practical Example
- Working with All Metadata Update Procedures
- Aliases: Examples and Updates
- Bulk Updating of aliases
- Inserting New Objects Using Batch Mode
- Creating New Objects with Auto Numbering
- Deleting Duplicate Objects in M-Files
- Deleting Objects in M-Files
- Get Deleted Objects
- Destroy Object Versions in M-Files
- Create Lookup Views for Value Lists and Workflow States
- Updating Value List Items
- Working with Workflows
- Resetting Workflow State Names on All Class Tables
- Using update filters: ObjIDs
- Using update filters: last modified date
- Ad hoc columns on class tables
- inserting new objects using transaction update
- Inserting new objects using lookup views
- Insert Records with single lookup columns
- using spmfupdatetableInbatches for batch updates
- Comparing procedures for large volume updating
- Using multilookup upsert
- using record by record update
- Create public shared link
- Get Object History records
- Adding comments to object
- Get Comments using Change History
- Get Workflow state changes using Change History
- Get all changes for object with Change History
- Getting History in high volume situations
- Delete history logging tables
- understanding history tables
- Uploading Blob Files into M-Files
- Updating the ContextMenu
- Getting ready for reporting
- using Search object
- using updatetable filters - UserID
- Using user messaging
- sending bulk emails with attachements
- using auto correction of synchronization errors
- TableAudit and classtablestats
- Example of SyncPrecedence 0 (SQL takes precedence)
- Example of SyncPrecedence 1 (MF takes precedence)
- Analyse Class table columns
- Explorer impact of multi lookup property changes
- Using functions in custom procs
- Reporting_PerformanceAnalysis
- agent for update context menmu queue
- Example - Sync Procesure
- 70 101 Example - Sync Process - Test wLogging
- Example - Sync Process - Test
- Example - Sync Process - Check Progress
- Example - Start Job Wait - Agent
- Template - custom procedure
- custom DoCMObjectAction
- custom DoCMAction
- custom DoCMObjectActionForWorkFlowState
- custom DoCMAsyncAction
- Custom CMMFiles_UpdateSQL
- Custom DoAccountConfirmationEmail
- Export and use M-Files event log