MFSQL Connector

FAQ:

  • Frequently asked questions

MFSQL Connector Guide:

  • Introduction to MFSQL
  • Getting Started
  • MFSQL Data Exchange and reporting Connector
  • MFSQL Integration Connector
  • The Connector Framework
  • Version Control
  • Version 5 Development

Blog:

  • List of blogs

SQL Components:

  • Procedures
  • Tables
    • MFAuditHistory
    • MFAuthenticationType
    • MFObjectChangeHistoryUpdateControl
    • MFClass
    • MFClassProperty
    • MFContextMenu
    • MFContextMenuQueue
    • MFDataType
    • MFDeploymentDetail
    • MFEmailTemplate
    • MFEmailLog
    • MFEventLog_OpenXML
    • MFExportFileHistory
    • MFFileExportControl
    • MFFileImport
    • MFLog
    • MFLoginAccount
    • MFObjectChangeHistory
    • MFObjectType
    • MFProcessBatch
    • MFProcessBatchDetail
    • MFProperty
    • MFPublicLink
      • Columns
      • Used By
      • Changelog
    • MFSearchLog
    • MFSettings
    • MFUpdateHistory
    • MFUserAccount
    • MFValueList
    • MFValueListItems
    • MFWorkflow
    • MFWorkflowState
    • MFilesEvents
  • Functions
  • Views
  • Triggers
MFSQL Connector
  • Docs »
  • Tables »
  • MFPublicLink

MFPublicLink¶

Columns¶

Id int (primarykey, not null)

SQL Primary Key

ObjectID int
  • ObjID column of the Record

  • Use the combination of objid and class_ID to join this record to the class table

ClassID int

Class_ID of the Record

ExpiryDate datetime

Expiredate used in Access Key

AccessKey nvarchar(4000)

Unique key generated by M-Files using the Assembly

Link nvarchar(4000)

Constructed link

HtmlLink nvarchar(4000)

HTML constructed link to be used in emails. The name of the document is used as the friendly name of the link

DateCreated datetime

Date item was created

DateModified datetime

Date item was last udated

Used By¶

  • spMFCreatePublicSharedLink

Changelog¶

Date

Author

Description

2019-09-07

JC

Added documentation

2016-04-10

LC

Create table

Next Previous

© Copyright 2023, Laminin Solutions Ltd

Built with Sphinx using a theme provided by Read the Docs.