In some cases, we need to modify the values of system fields. Below is a code example of how to do this. The key points are the "OverwriteSystemFieldsPermission" and "overwriteSystemFields" commands:
public void insert()
{
// Assert and enable the system overwrite permission
and metadata property.
new OverwriteSystemfieldsPermission().assert();
this.overwriteSystemfields(true);
this.setAuditFieldsAnonymous();
super();
// Revert and disable the system overwrite permission
and metadata property.
this.overwriteSystemfields(false);
CodeAccessPermission::revertAssert();
}
public void update()
{
// Assert and enable the system
overwrite permission and metadata property.
new OverwriteSystemfieldsPermission().assert();
this.overwriteSystemfields(true);
this.setAuditFieldsAnonymous();
super();
// Revert and disable the system overwrite permission
and metadata property.
this.overwriteSystemfields(false);
CodeAccessPermission::revertAssert();
}
public void setAuditFieldsAnonymous()
{
utcdatetime now = DateTimeUtil::utcNow();
SysDictField createdByField;
SysDictField createdDateTimeField;
SysDictField modifiedByField;
SysDictField modifiedDateTimeField;
fieldNum(Table, CreatedBy));
createdDateTimeField = new SysDictField(tableNum(Table),
fieldNum(Table, CreatedDateTime));
modifiedByField = new SysDictField(tableNum(Table),
fieldNum(Table, ModifiedBy));
modifiedDateTimeField = new SysDictField(tableNum(Table),
fieldNum(Table, ModifiedDateTime));
if (createdByField.isSQL())
{
this.(fieldNum(Table, CreatedBy)) = '';
}
if (modifiedByField.isSQL())
{
this.(fieldNum(Table, ModifiedBy)) = '';
}
if (modifiedDateTimeField.isSql())
{
this.(fieldNum(Table, ModifiedDateTime)) = now;
}
if (this.RecId == 0 && createdDateTimeField.isSql())
{
// CreatedDateTime is only set on
insert.
this.(fieldNum(Table, createdDateTime)) = now;
}
}
