MFContextMenuQueue

The queue table is specifically designed to manage update calls from M-Files to SQL using context menu action type 5. Queue control should be put in place where users can update multiple objects in M-Files and a event handler with action type 5 fires multiple consecutive updates to SQL.

Columns

The rows for this table is inserted from your custom contextmenu procedure

Example xx illustrates how the functionality is built into the custom procedure.

Additional Info

Indexes

idx_ContextMenuQueue_ObjType_ObjID

• ObjectType

• ObjID

idx_ContextMenuQueue_Class_Objid

• Class

• ObjID

Foreign Keys

Uses

MFContextMenuQueue

Used By

spmfUpdateContextMenuQueue custom procedures

Examples

Select * from MFContextMenuQueue

    SELECT mot.name AS objecttype, mc.name AS Class, mcmq.ObjectID,mcmq.ObjectVer
FROM dbo.MFContextMenuQueue AS mcmq
INNER JOIN dbo.MFClass AS mc
ON mcmq.classID = mc.MFID
INNER JOIN dbo.MFObjectType AS mot
ON mot.MFID = mcmq.ObjectType

Changelog

Date	Author	Description
2022-03-10	LC	Reset log table to align with VAF Job Task processing
2020-04-22	LC	Add naming for primary key
2020-03-18	LC	Add indexes
2019-12-06	LC	Create Table