MFObjectChangeHistory¶
Columns¶
- ID int (primarykey, not null)
SQL primary key
- ObjectType_ID int
MF ID of the object Type of the class
- Class_ID int
MF ID of the class
- ObjID int
ObjID of the object
- MFVersion int
Version of the object where the value changed for the property in column Property_ID
- LastModifiedUtc datetime
The ‘CheckInTimeStamp of the specific version for the object
- MFLastModifiedBy_ID int
MF ID of the user
- Property_ID int
MF ID of the property
- Property_Value nvarchar(300)
Value as a string
Interpreting and relating to this value will depend on the type of property.
- CreatedOn datetime
Timestamp when row was created
- Process_id int
default = null This column is used to process change history deletions
Additional Info¶
Get values related the the ObjectType using MFclass table. The MFObjectTyoe_ID on MFClass table references the ID column in MFObjectType table.
Only versions matching the filters on the spMFGetHistory procedure is fetched. Widening the filters may restrict the MFVersions returned. Narrowing the filters will not remove the rows previously fetched for the object.
The timestamp is shown in Universal Time.
Used By¶
Procedures - spMFGetHistory - spMFUpdateObjectChangeHistory
Views - MFvwObjectChangeHistory
Changelog¶
Date |
Author |
Description |
2023-09-07 |
LC |
Increase size of property_value to 4000 |
2020-10-11 |
LC |
Add column for process_id |
2019-09-07 |
JC |
Added documentation |
2017-02-10 |
DevTeam2 |
Create Table |