This question is locked. New answers and comments are not allowed.
I have a requirement that key objects have some change tracking capabilities.
The current plan is to have the key objects have the following columns:
[version] int DEFAULT 1 NOT NULL, -- Current version number.
[versionUserID] uniqueidentifier NOT NULL, -- The user id of the last person to edit the record. (ASP.NET User ID)
[versionDate] datetime NOT NULL, -- The UTC Date Time the version was saved
[creatingUserID] uniqueidentifier NOT NULL, -- The user id of the person that created the record. (ASP.NET User ID)
[createdDate] datetime NOT NULL -- The UTC date/time the record was created.
I would then need to track when a property gets changed and record the values. I understand that I can quickly do this via the ITracking interface.
I could use some recommendations/advice since I am a OA newbie.
Thanks,
Ed
The current plan is to have the key objects have the following columns:
[version] int DEFAULT 1 NOT NULL, -- Current version number.
[versionUserID] uniqueidentifier NOT NULL, -- The user id of the last person to edit the record. (ASP.NET User ID)
[versionDate] datetime NOT NULL, -- The UTC Date Time the version was saved
[creatingUserID] uniqueidentifier NOT NULL, -- The user id of the person that created the record. (ASP.NET User ID)
[createdDate] datetime NOT NULL -- The UTC date/time the record was created.
I would then need to track when a property gets changed and record the values. I understand that I can quickly do this via the ITracking interface.
I could use some recommendations/advice since I am a OA newbie.
Thanks,
Ed