MFValueList

Columns

ID int (primarykey, not null)

SQL Primary Key

Name varchar(100)

Name of the valuelist from M-Files

Alias nvarchar(100)

Alias from M-Files

MFID int

M-Files ID

OwnerID int

Owner MFID

ModifiedOn datetime (not null)

When was the record last modified

CreatedOn datetime (not null)

When was the record created

Deleted bit (not null)

Is deleted

RealObjectType bit

set to 1 if valuelist is an full object type with classes and properties

Additional Info

The column OwnerID references the Owner Valuelist MFID or ObjectType MFID in the case of real ObjectTypes. For example: ‘State’ is owned by ‘Workflow’.

-1 indicates no owner

Indexes

idx_MFValueList_1

  • ID

  • Name

udx_MFValueList_MFID

  • Name

  • MFID

USAGE

Select * from MFValueList

Changelog

Date

Author

Description

2019-09-07

JC

Added documentation