2. PHPRunner General questions
  3. Audit Tracking
This topic is locked

Audit Tracking

 		1/14/2014 5:56:51 AM
PHPRunner General questions
S
 swanside author

On my tables, the majority of them have Job_No as the primary key. Now when a user logs in, and alters anything, it stores the alterations in the audit table, but I want to link these to the actual table which will be accessible on the View Pages.

The only link I have is in the audit description field which contains data like

---Keys

Job_No : 1037449

---Fields

Job_Finished [old]: 0

Job_Finished [new]: 1

Note [old]:

Note [new]: SHEETS PRINTED


Cheers

Paul.
Sergey Kornilov admin 1/14/2014

You need to use a custom OnAuditLog event if you want to change the way audit data is saved in audit log:

http://xlinesoft.com/phprunner/docs/before_audit_log.htm