AutoUpdate and Audit Trail

digitalphotoworld · Post by **digitalphotoworld** » Sun Jan 18, 2015 1:02 am

I have a table with activated audit-trail for edit records. Two of the fields are autoupdate-fields (logging user and date).
If a user clicks on edit record and leaves the page immediatly by clicking the submit button without changing any field, a change in audit trail is written about this action.

How could I prevent this behavior?

mobhar · Post by **mobhar** » Sun Jan 18, 2015 10:55 am

You need to customize PHPMaker template file, see the code in "WriteAuditTrailOnEdit" function from the "audittrail.php" file. You may compare between the old and new value. If they are the same then do not call "ew_WriteAuditTrail" function, otherwise just call it as usual.

digitalphotoworld · Post by **digitalphotoworld** » Sun Jan 18, 2015 10:57 pm

Can I disable writing to audittrail on the fly e. g. in Server Event row_inserting?

mobhar · Post by **mobhar** » Mon Jan 19, 2015 9:25 am

Yes, you can. To disable the audittrail in "Row_Inserting" server event, you may simply use:

$this->AuditTrailOnAdd = FALSE;